Viewing 15 posts - 34,606 through 34,620 (of 39,793 total)
I believe you are correct in that SQL needs to restart.
October 4, 2004 at 11:18 am
I tend to agree. I'd hope that more people are concerned about learning and would think about it before testing in QA. Same for checking BOL before thinking or guessing.
October 4, 2004 at 9:19 am
There are times this doesn't work because of the virtual log files. If you can't get it to shrink, try this script:
http://www.sqlservercentral.com/scripts/contributions/26.asp
October 1, 2004 at 6:24 am
That works great for the same server. Typically in this scenario, the backup is coming from another server, or being pushed to another server. Still this would help with identifying...
September 29, 2004 at 11:18 am
I'm a little confused. What does this tool do? I've allowed the network admins to have the sa password as they have been my remote hands before, but only when...
September 25, 2004 at 6:23 pm
When you detach, all transactions will complete or rollback. The update statistics is to ensure they are up to date before you detach.
September 24, 2004 at 2:34 pm
There is no way to determine this after the fact. If you are getting deadlocks, use the hints above to setup a trace and look for them.
September 24, 2004 at 10:17 am
Rather than search for the city name, what about searching for the state and then adding the comma before it?
September 23, 2004 at 10:03 pm
Get the performance plan from Query Analyzer. CTRL-K should turn it on. Run your query and then look at the performance plan. It will clue you in to the sections...
September 23, 2004 at 10:00 pm
Be sure this SMS account has rights to connect to SqL Server. It logs in like any other user of SQL Server.
September 22, 2004 at 10:04 am
See the other thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=138256
September 22, 2004 at 9:49 am
You might try the compare tools from Red Gate and Apex SQL to see if they handle this.
September 21, 2004 at 11:06 am
I believe the autoval column in syscolumns has a value for identity coluymns.
September 21, 2004 at 11:05 am
Escape it by doubling them up.
select * from table1 where name like '%''%'
September 20, 2004 at 4:07 pm
Viewing 15 posts - 34,606 through 34,620 (of 39,793 total)