Viewing 15 posts - 39,031 through 39,045 (of 49,571 total)
Eric Butler (5/19/2009)
Example, under CREATE DATABASE ...
Therefore, when you...
May 20, 2009 at 12:36 am
Not as far as I'm aware.
In fact, it's a reasonably well known 'trick' to add "--password" to the end of a query to stop profiler from showing the code for...
May 19, 2009 at 4:58 pm
Eric Butler (5/19/2009)
My ultimate goal is to:
1 - detach a log-shipped database (databaseA) which...
May 19, 2009 at 4:48 pm
Tim Walker (5/19/2009)
The DATA_PURITY option just performs more limited checks.
DATA_PURITY
Causes DBCC CHECKDB to check the database for column values that are not valid or out-of-range. For example, DBCC CHECKDB detects...
May 19, 2009 at 4:46 pm
What are the names of those files?
SQL wouldn't be writing to that directory unless something was configured to write there.
May 19, 2009 at 9:02 am
Lynn Pettis (5/19/2009)
May 19, 2009 at 8:25 am
TheSQLGuru (5/19/2009)
GilaMonster (5/19/2009)
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.I almost hope it is.
I wish it...
May 19, 2009 at 7:58 am
linhdkl (5/18/2009)
it's very very simple .... because I don't want anything more than a solution...
May 19, 2009 at 7:54 am
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.
I almost hope it is.
May 19, 2009 at 7:50 am
Please run the following and post the full results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
May 19, 2009 at 5:43 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic719574-5-1.aspx
May 19, 2009 at 5:41 am
Does the SQL Server Service account have rights to the directory where the backup file is?
May 19, 2009 at 5:39 am
OpenTran just looks for open transactions, but any connection, even if it's not running a query will prevent an exclusive DB lock.
Why are you running checkDB with the TABLOCK option?...
May 19, 2009 at 5:38 am
You don't prepare the execution plan. When you run the query, SQL generates an exec plan as part of the execution.
If you're trying to see the exec plan, there's...
May 19, 2009 at 5:37 am
Viewing 15 posts - 39,031 through 39,045 (of 49,571 total)