Viewing 15 posts - 19,246 through 19,260 (of 26,490 total)
For routine work, neither Developers or DBAs actually need sysadmin rights to production databases. That is how mistakes happen that can be avoided. Developers shouldn't even have db_owner...
August 12, 2009 at 10:10 am
Hah! Looks like a Rookie used the Force on the Mighty Gila! 😉
August 12, 2009 at 10:04 am
I didn't forget, I just spent most of last night figuring out a problem I was having here at work. Hopefully tonight I may get some time to look...
August 12, 2009 at 10:01 am
steve_melchert (8/12/2009)
August 12, 2009 at 9:58 am
You can't restore a SQL Server 2008 backup to SQL Server 2005. If you need to move/deploy a database from SQL Server 2008 to SQL Server 2005, you need...
August 12, 2009 at 9:47 am
ChrisMoix (8/12/2009)
Last time we hired a DBA I was stunned at how many applicants had good SQL skills, but Zero .NET, Zero CLR skills. I know, I know, some...
August 12, 2009 at 9:12 am
Faiyaaz (8/12/2009)
August 12, 2009 at 8:51 am
Please read the second article in my signature block regarding asking for assistance on performance problems. Based on your post, there really isn't much we can do to help...
August 12, 2009 at 8:34 am
NewbieCoding (8/12/2009)
@Col1 int = null,
@col2 datetime = NULL,
@col3 int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
...
August 12, 2009 at 8:30 am
You will have to reinstall SQL Server 2005. There is no uninstall at this time for service packs. I think this may change in the future, possibly with...
August 12, 2009 at 8:04 am
descentflower (8/12/2009)
Thanks :w00t: thats what i neededIs this magic of recursion ?
I will be very thankful if you give a brief idea of that query.
Thanks again.
Read about Recursive CTE's...
August 12, 2009 at 7:55 am
rja.carnegie (8/12/2009)
August 12, 2009 at 7:52 am
WilliamB (8/12/2009)
Nevermind, I found it... 😀
What did you find? Details please, someone else may have the same question.
August 12, 2009 at 6:31 am
Not really sure what you are asking here. Could you provide more information about what you are trying to accomplish?
August 12, 2009 at 6:27 am
Viewing 15 posts - 19,246 through 19,260 (of 26,490 total)