Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
KH, will that work only on SQL 2008? I am on SQL 2005 and it doesn't work for me.
madhivanan
Premature Yak Congratulator
22864 Posts
Posted - 2011-12-27 : 08:42:20
quote:Originally posted by sunitabeck KH, will that work only on SQL 2008? I am on SQL 2005 and it doesn't work for me.
Make sure the compatibility mode is set to 90 MadhivananFailing to plan is Planning to fail
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts
Posted - 2011-12-27 : 09:14:23
Do not forget to mark his answer as accepted!http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
madhivanan
Premature Yak Congratulator
22864 Posts
Posted - 2011-12-27 : 09:21:28
quote:Originally posted by DonAtWork Do not forget to mark his answer as accepted!http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
MadhivananFailing to plan is Planning to fail
Sachin.Nand
2937 Posts
Posted - 2011-12-27 : 13:42:15
I wonder how Visakh missed this post ? PBUH
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts
Posted - 2011-12-27 : 13:45:56
quote:Originally posted by Sachin.Nand I wonder how Visakh missed this post ? PBUH
I think he answered it before it was asked. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
Sachin.Nand
2937 Posts
Posted - 2011-12-27 : 13:48:33
quote:Originally posted by DonAtWork
quote:Originally posted by Sachin.Nand I wonder how Visakh missed this post ? PBUH
I think he answered it before it was asked. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp