Viewing 15 posts - 29,896 through 29,910 (of 39,921 total)
Comparisons usually require a line by line marking and T-SQL isn't good at this.
Word does this if you select the "Track Changes" menu item. This works pretty well and you...
January 23, 2008 at 6:48 am
You should get the Express Edition of SQL Server with VS and I don't think it includes SSMS.
January 23, 2008 at 6:46 am
My business partner, Brian Knight, can build a cluster in an hour. I'd expect you can install SQL Server in a cluster easily in under a day. Maybe a day...
January 23, 2008 at 6:45 am
Perhaps you could also show the code you're running and explain what you're trying to do. Just showing error messages doesn't really help. Would you ask someone a question like...
January 23, 2008 at 6:42 am
I'd also look at the Inside SQL Server book on queries. That will help with tuning.
January 23, 2008 at 6:41 am
Can't add any more data to tables on that file.
January 23, 2008 at 6:40 am
I tend to agree with Andras that there may be a better way to do this other than a trace.
January 23, 2008 at 6:39 am
Second vote for Toni's solution. Maybe script this as part of the database creation or restore)
January 23, 2008 at 6:38 am
Sometimes those things are true, but not always.
It can limit your ability to advance. Many positions as you go up in the company require that you be at the office.
It...
January 22, 2008 at 9:34 pm
Everyone please take a step back and calm down. I don't think Jeff meant anything, but everyone please discuss the topic only.
January 22, 2008 at 9:27 pm
It's executed as the SQL server Agent logon. So it's not the console where you logged on, it's a separate console for that user.
Even if you use your use ID,...
January 22, 2008 at 9:42 am
That is very strange. If you create a new proc, same code, including the cmdshell, does it work?
January 22, 2008 at 9:39 am
Programs -> Microsoft SQL Server 2005 -> SSMS
Be sure you installed client tools. This is not required, so if you don't have the group, run the install again and just...
January 22, 2008 at 9:31 am
Viewing 15 posts - 29,896 through 29,910 (of 39,921 total)