What is the bandwidth the main site and the DR Server.... Because that is going to be critical.I hope DR is not over IPLC... From: sqlcon@yahoogroups.com...
I think with DR u mean disaster recovery server and what is IPLC? Please correct me if i am wrong. Right now the band width of the network is 1 GB. As this...
Hi I have a db with 300+ tables working fine. Now the client wants to include AUDIT on some tables only on specific columns. An UPDATE trigger on the selected...
Try this: select sum(datediff(mi,elogintime,elogouttime)/60) as DurationHours from logintable Pavel Alexandrov ... login & ... DURATION i ... duration...
hi, can anybody help me on this topic I have a mySQL query like the following:SELECT wo.CREATEDTIME FROM woThe result is supposed to be a list of date in a...
I Need to update sysdatabases. But i am unable to update it as error "Ad hoc updates to system catalogs are not allowed." Then I tried to execute: USE MASTER ...
Hi Manish, Could you let me know the SQL server version and what are the tables you are trying to update? No direct edits to any system information is allowed ...
i am working on SQL 2000. I need to update sysdatabases, as i have to update category column to 0 as some of the DB are not part of replication, but still its...
Hi SqlCon Members, i have created procedure as below. create proc proc1 as begin select * from emp --dbcc inputbuffer(@@spid) end go exec Proc1 go i need to...
Hi I have a table in 2005 and has to be migrated to 2000. Using Import/Export wizard in 2005 the migration is done and found a Trigger, Default values on...
Hi All, I am having server A in Location A,Server B in Location B.Bothare in Windows server 2003,SQl Server 2000.Both servers are having same DataBase named...
Hi You can use los shipping to synconize. For more details how to implement log shipping you can use website sql-server-performance.com or sqlservercentral.com...
hi, how to retrive a daynumber if date is given in sql server thanks in advanve pha RAJESHWAR REDDY <srajeshwar@...> wrote: Hi All, I am having server A...
SELECT DAY(GETDATE()) ... From: phani r To: sqlcon@yahoogroups.com Sent: Thursday, November 15, 2007 2:02 PM Subject: MUGH-SQLCON Change a DATE to a day number...
Dear Rajeshwar, you can use : select datepart(dd,getdate()) Best Regards Sunil John ... From: phani r <phanisletters@...> To: sqlcon@yahoogroups.com ...
Thanks Roji i would like to change date to day number the procedure accept daynumber and return date finally i got it ...... can you please try to optimize it ...
Well, it can be as simple as DECLARE @DayNum Int SET @DayNum = 23 SELECT CONVERT(VARCHAR,(GETDATE() - DAY(GETDATE()))+ @DayNum, 106) Regards Roji ... From:...
Hi Roji, Thanks for reeply your code returns 23rd Nov 2007 but it should return 23rd Jan 2007 becuse 23rd day of 2007 year is not 23rd November it is 23rd Jan...
Thats more easy. DECLARE @DayNum Int SET @DayNum = 23 SELECT CONVERT(VARCHAR,CAST(CAST(YEAR(GETDATE()) AS CHAR(4))+'0101' AS DATETIME)+ (@DayNum-1), 106) ... ...
Hi Roji/Phani, This can be done in this manner. DECLARE @DayNum Int SET @DayNum = 23 SELECT CONVERT(VARCHAR,GETDATE() - Datepart(y,GETDATE())+ @DayNum, 106) ...
Hi all, I am planning to start a new company specializing Database Administration (MS SQL, Oracle) If you guys know any Good/best name please reply back to...
Wonderfull Idea, You should also include datawarehousing, data auditing, data security, data mining, reporting , data analyzing etc to ur scope. _____ From:...
Varra, All the best for your new concern. How about "data"? Pls make sure that you address the performance tuning, Master Data Management and database...
Guys, i have used index tuning wizard in SQL 2000 a couple of times. as i remember i recommends us on a table where should we create a index. i need to do it...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
