Viewing 15 posts - 41,626 through 41,640 (of 49,571 total)
matsinopoulos (1/18/2009)
So, I would imagine it is quite common to use a cursor to traverse table X. No?
No!
That's a single update statement, no need to do it row by...
January 18, 2009 at 10:42 am
ravikanth (1/18/2009)
1204 - This trace flag reports deadlock information formatted by each node involved in the deadlock
1222 - This trace flag formats deadlock information, first by processes and then...
January 18, 2009 at 10:39 am
Enable traceflag 1222. You can use use a DBCC statement (DBCC TRACEON(1222,-1)), or add -t1222 to the startup parameters of the SQL instance (needs a restart to take effect)
Once that...
January 18, 2009 at 9:33 am
ashish_1279 (1/18/2009)
I tried to restore Backup of same to Microsoft SQL 2005 Server again it did notwork. Its ggiving downgrade compatibility error.
Can anybody suggest how to do that ??
Short answer,...
January 18, 2009 at 9:23 am
Steve Jones - Editor (1/18/2009)
I've scheduled re-runs on Fridays for a few months since content has been a touch thin. Hint, hint, new articles anyone?
I've got one that's getting tech-reviewed...
January 18, 2009 at 9:17 am
You can write one yourself, based off sys.tables, sys.column and sys.types. It's not difficult, thought it is a it tedious to write (I don't have one, but I did similar...
January 18, 2009 at 8:48 am
You need to give more information here. A lot more.
What's your manager talking about migrating?
SQL CLR is the CLR (the common language runtime) within SQL Server (2005+). It allows...
January 18, 2009 at 6:18 am
Of course, as long as you're in full or bulk logged recovery and nothing has truncated the log since the diff.
January 18, 2009 at 3:09 am
No.
Insert the data into a temp table that has an identity and then select with the identity column.
Please post SQL 2000-related questions in the SQL 2000 forums.
January 18, 2009 at 2:54 am
When was the previous log backup? Was there anything that broke the log chain since then (switch to simple, truncate only)?
January 18, 2009 at 2:53 am
Please don't start new threads for existing questions. It just leads to duplicate replies and wastes people's time.
Asked and answered - http://www.sqlservercentral.com/Forums/FindPost638856.aspx
No replies to this thread please.
January 18, 2009 at 2:52 am
RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Agreed. Steve, can you republish this?
January 18, 2009 at 2:49 am
What type are they at the moment?
January 18, 2009 at 2:38 am
What kind of CLR stuff do you have? Just asking in general about migrating it's a pretty vague question.
January 18, 2009 at 2:37 am
matsinopoulos (1/18/2009)
Hi,I was wondering whether there is any similar construct in SQL Server 2008 with what one has in Oracle as ROWTYPE.
No. You'll have to do it the hard way.
Aside,...
January 18, 2009 at 2:37 am
Viewing 15 posts - 41,626 through 41,640 (of 49,571 total)