Viewing 15 posts - 91 through 105 (of 149 total)
Doesn't that feature require a MAPI client like Outlook to be installed?
March 9, 2009 at 1:09 pm
Did you set the intial RAM size in SQL to at least 10240MB (10GB)?
Are you just looking from "Task Manager"? If so, it will not show the eunning instance of...
March 9, 2009 at 11:03 am
Nevermind, I found it. http://msdn.microsoft.com/en-us/library/ms187797.aspx
Murphy's law, post your question and you'll find the answer 2 minuteas afterwards....
lol..
January 28, 2009 at 2:35 pm
No dice. It doesn't look like it is returning the entire trigger script. These triggers have at least a min on 100 lines it them. Your scrip only returns the...
January 23, 2009 at 2:44 pm
My fault, I forgot to do outout as text.
OK looks like it may work but the addition of the 'Go' statement isn't there. I'll tweak it a bit...
January 23, 2009 at 2:37 pm
The text formatting is all over the place and I get the error..
Incorrect syntax near 'inserted'.
Most likely because the text is all on a single line.
Any way of changing it...
January 23, 2009 at 2:20 pm
Thanks but no.
I may have not been clear on what I want. I need to script out EVERY trigger as like a "Create to..." to a text file so I...
January 23, 2009 at 1:37 pm
lol...
I was thinking the same thing.
She must speak in HEX.
December 30, 2008 at 2:07 pm
"Restart the SQL service."
I knew you were going to say that.
What drew it to my attention is the test server ran out of space. I increased it to add a...
December 30, 2008 at 2:03 pm
I checked the db properties and the physical size of the tempdb.mdf.
If they do not decline in size, what is the process to kill the tables other than rebooting?
Thanks
December 30, 2008 at 1:48 pm
"table variables"?
These tables are taking 30GB of space for the tempdb.mdf. Will SQL eventually delete these?
December 30, 2008 at 1:36 pm
Just curious, what's the CPU usage and the disk i/o? if both are pinned then you have a major issue. If both are not pinned then I don't see anything...
December 30, 2008 at 1:28 pm
This may sound convoluted but it's only to protect your production data....
Take the same DB "AM20" and restore over a SQL 2000 server as a different name "AM20_Convert". Fix the...
December 17, 2008 at 3:03 pm
Log into a SQL 2005 server....
Open SQL Server Management Studio....
Direct the login to the SQL 2000 server...
Navigate to your SQL jobs you want to migrate...
Right click the job and select...
December 17, 2008 at 2:50 pm
hmm...
OK, let me rephrase the question. How do I check for "Orphaned" records?
November 12, 2008 at 4:14 pm
Viewing 15 posts - 91 through 105 (of 149 total)