Viewing 15 posts - 45,316 through 45,330 (of 49,571 total)
Looks like this is the syntax. Can't test. Don't have any named instances around.
If you're using windows authentication
sqlcmd -S servername\instancename -E -A
If you're using SQL authentication
sqlcmd -S servername\instancename -U...
August 1, 2008 at 8:31 am
Off hand, I don't know. What does Books Online say? 😉
August 1, 2008 at 8:29 am
Connections via the DAC don't fire login triggers. From management studio, open a new query and specift admin: before the server name (admin:MyServerName) and use windows authentication. You must be...
August 1, 2008 at 8:17 am
Is the database set to autoclose?
Are there any databases on the server that are the target of a logshipping scenario (getting logs restored regularly)?
Is there a scheduled job that's freeing...
August 1, 2008 at 8:13 am
Is there a question here?
August 1, 2008 at 8:09 am
Paresh Randeria (8/1/2008)
This database is full recovery and we are not talking Log back....
August 1, 2008 at 7:58 am
Could you be a bit more specific about the problem please?
August 1, 2008 at 7:41 am
Duplicate post. Direct replies to the following thread please.
http://www.sqlservercentral.com/Forums/Topic545117-149-1.aspx
August 1, 2008 at 7:41 am
Simon (8/1/2008)
August 1, 2008 at 7:36 am
1204 and 1205 write deadlock graphs and associated info into the SQL error log. If you aren't having deadlocks, you won't see anything written. I wouldn't usually suggest using both....
July 31, 2008 at 1:17 pm
Adam Bean (7/31/2008)
July 31, 2008 at 1:10 pm
Both full and bulk-logged recovery models require log backups. If you don't have log backups, the transaction logs will grow without bound (as you've noticed). You can have a look...
July 31, 2008 at 11:32 am
Full recovery mode?
Any log backups running?
Any replication running?
Do you have a point-in-time recovery requirement for these databases?
If you run the following query, what does it say for the offending databases?
SELECT...
July 31, 2008 at 10:26 am
lee.vance (7/31/2008)
Hey Gail,What you are saying is exactly what is happening. When my stored proc ends, it deletes the temp tables even when I remark out the DROP statement.
Because...
July 31, 2008 at 10:23 am
Don't forget to set the DB to simple recovery mode or schedule log backups.
July 31, 2008 at 10:04 am
Viewing 15 posts - 45,316 through 45,330 (of 49,571 total)