Viewing 15 posts - 40,696 through 40,710 (of 49,571 total)
March 2, 2009 at 6:43 am
Ratheesh.K.Nair (3/2/2009)
I tried using a Hex editor but I am not able to figure it out.
There probably aren't more than a handful of people who know the page structure well...
March 2, 2009 at 6:42 am
How many other files are in the same filegroup as the one you're trying to empty, how big are they and how much space is available in each?
March 2, 2009 at 6:03 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here if...
March 2, 2009 at 5:56 am
Ratheesh.K.Nair (3/2/2009)
Can you please explain? I tried opening in notepad but i didnt find anything..
Notepad is not a hex editor.
Unless you are intimately familiar with the structure of database pages,...
March 2, 2009 at 5:53 am
cshekhar (3/2/2009)
Simply i need to remove this protection in some cases, for that scenario how can i ?
Disable the trigger.
A better approach than a DDL trigger would be to ensure...
March 2, 2009 at 5:12 am
pedro.ribeiro (3/2/2009)
In my case , i have the same problem (suspect database).
Please post your problem in a new thread in the appropriate forum (SQL 2000 is this...
March 2, 2009 at 5:09 am
Short of opening the mdf in a hex editor and finding the version code in the header page, no.
March 2, 2009 at 5:06 am
AShehzad (3/2/2009)
Now, I have to get columns of temp table from information_schema.columns
Why? The only tables that should be in tempDB are temp tables that your session has created. Hence...
March 2, 2009 at 5:01 am
cshekhar (3/2/2009)
But i can see the data which is after the reboot (StartTime), but i need the information of before recycle.
There should be 5 trace files. What about the...
March 2, 2009 at 5:00 am
A Little Help Please (3/2/2009)
Question, what do you mean by:Compat mode 80/90?
Look up Compatability level in Books Online
How would I:
update all statistics on 2005
Look up UPDATE STATISTICS in Books Online
run...
March 2, 2009 at 4:57 am
ALZDBA (3/2/2009)
GilaMonster (3/2/2009)
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether...
March 2, 2009 at 4:21 am
Either will work. Check compatibility before you move to 2005 (test restore, update advisor) as there's stuff that breaks even in compat mode 80.
Once on 2005 update all statistics, run...
March 2, 2009 at 3:47 am
Providing the default trace is running, and the table wasn't dropped too long ago, you can use that.
The default trace is 5 trace files of 20MB apiece that are put...
March 2, 2009 at 3:46 am
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether it's the...
March 2, 2009 at 3:41 am
Viewing 15 posts - 40,696 through 40,710 (of 49,571 total)