Viewing 15 posts - 31 through 45 (of 71 total)
Looks like this was a code change in 2005; works fine in 2005/2008 but not in 2000, which unfortunately is what we're using here.
February 22, 2010 at 8:57 am
Agreed, but I was still getting the error using NORESEED, as per my post. I'm guessing the DBCC code does a BEGIN TRAN whether you want it to reseed...
February 20, 2010 at 2:06 am
Just in case anyone finds this post later on, when I tried to run
DBCC CHECKIDENT(MyTableName, NORESEED)
while the database was in standby (read only) I got the following error:
Msg 3906, Level...
February 19, 2010 at 4:45 am
Surely this depends entirely on the usage patterns of the affected systems? We have some servers that are used mainly in the morning (eg 7am - 2pm) so we can...
February 19, 2010 at 2:01 am
I've actually brought the db online now and CHECKIDENT is not showing anything unexpected. CHECKDB didn't return any errors either.
Not sure what exactly caused errors but db and table appear...
February 6, 2010 at 12:51 pm
Does anyone else think that, while this looks like a decent tool which gives quite a thorough report, it is vastly over-priced?
We have about 60 servers here and I have...
February 8, 2007 at 9:31 am
Thanks for this. You are right, both options are set OFF for the proc.
Can you explain why this would affect the generated execution plan?
October 24, 2006 at 3:29 am
SELECT work_code AS [Work
Code], work_nature AS [Work
Nature]
FROM sb_cm_work_nature
If you're doing this from Query Analyzer you will need to be in "results to text" mode to see it.
July 14, 2005 at 2:44 am
baxterg is correct. Here is another way of viewing the table variable in tempdb:
SELECT id INTO tmp
FROM tempdb..sysobjects
GO
DECLARE @t table (a int)
SELECT *
FROM tempdb..sysobjects
WHERE id NOT IN (SELECT id...
July 14, 2005 at 2:40 am
Not having any experience of SQL 2005 yet, I had to make an educated guess on this one. Was I the only one to be tripped up by the...
May 27, 2005 at 2:16 am
That features comparison does not even mention Developer edition though so you need to look at that separately. When you do (eg, check the other link in the explanation)...
April 29, 2005 at 3:03 am
I thought this was a rather ambiguous question. The question asked how you would exclude JUST the oldest error log from the report. The correct answer to this...
April 26, 2005 at 2:39 am
While I appreciate that questions on relational theory are perfectly valid in a SQL Server environment (and maybe the last few days' questions have even taught me something!), are we...
March 15, 2005 at 2:59 am
After my previous post, I had a thought that maybe it wasn't always dbo that was the owner - maybe it was actually owned by the user executing the procedure...
March 4, 2005 at 4:17 am
I agree with David, my tests also show dbo as the owner of any temp object created in a proc.
This is the procedure I tested with. UserA is a...
March 4, 2005 at 4:12 am
Viewing 15 posts - 31 through 45 (of 71 total)