Viewing 15 posts - 961 through 975 (of 1,292 total)
I bought the printed edition of the book last weekend, all I have to say is it's a collectors edition.
I agree with Alex's view about not sharing the book with...
November 22, 2009 at 7:41 am
I have got a similar issue (not exactly the same) where my application team complained about 2 SQL servers having intermittent connection problems.
I made sure that have been changed their...
November 21, 2009 at 12:48 pm
chk2009 (11/20/2009)
Now i disabled logshipping...db's are recovery mode..Now i just want to make sure secondary server should be same as primary..I tested routing application to use secondary ...but throwung error...
November 21, 2009 at 12:37 pm
Hi,
I understand that is not simple, since you must be working in different time zone, I ma in EST in USA, so I could not reply in between, while you...
November 21, 2009 at 11:42 am
Hi,
The PackageB was having earlier the protection level "EncryptSensitiveWithUserKey", so SQL Server stored it there and needs that Key (what ever password) was initially given.
Who was the user who...
November 21, 2009 at 11:19 am
AVB (11/20/2009)
Yes you are correct... however there can be many jobs running at any one given time. I could see what jobs are running by using the Job Activity Monitor...
November 20, 2009 at 11:36 pm
Raghavender (11/20/2009)
Just for the sake of Knowledge.Ok, can I know any other applications like SAP which uses SQL Server, and also the companies or organisations using the SQL server.
What...
November 20, 2009 at 10:17 pm
Used the code given by you. Still not complete code.. at least as of now....
I get the following error
Msg 207, Level 16, State 1, Line 29
Invalid column name 'week_date'.
Msg...
November 20, 2009 at 9:14 pm
Tara-1044200 (11/20/2009)
D:\SQLDATA
D:\SQLLOG
Is there a script which queries windows folder to get list of all...
November 20, 2009 at 8:58 pm
Please find the Article I published, it covers almost everything you asked.
Comparing the High Availability Features in SQL Server 2005
What benefit does a transaction log backup have over a...
November 20, 2009 at 6:18 pm
apat (11/20/2009)
I want to find records from T2 which exists in T1 and make sure they are not inserted. Only those records...
November 20, 2009 at 6:00 pm
apat (11/20/2009)
Here is my scenario.
I have two tables T1 (Sid int not null, Pid int not null) & T2(Sid int, Pid int).
T1 has composite primary key on (sid,...
November 20, 2009 at 5:11 pm
srilu_bannu (11/20/2009)
SELECT *FROM sys.dm_db_index_physical_stats(DB_ID('AdventureWorks'), NULL, NULL, NULL , NULL);
I got the error like
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '('.
This sounds crazy to myself...
November 20, 2009 at 4:56 pm
srilu_bannu (11/20/2009)
Still getting the same tried many times .Do i need to create the function before i select sys.dm_db_index_physical_stats....
Thanks fo your reply.
You don't need to create any function.I too copied...
November 20, 2009 at 4:39 pm
AVB (11/20/2009)
Yes you are correct... however there can be many jobs running at any one given time. I could see what jobs are running by using the Job Activity Monitor...
November 20, 2009 at 4:25 pm
Viewing 15 posts - 961 through 975 (of 1,292 total)