Viewing 15 posts - 48,961 through 48,975 (of 49,566 total)
Because drop table is a logged operation and you are reqesting a rollback ie undo everything up to where the transaction began.
By the way, your code shouldn't even run. You...
November 8, 2006 at 3:34 am
Can you post the code of the stored procedures and the table structure please
November 8, 2006 at 3:31 am
Yes, it's one of the new SQL 2005 DM views. Since this is the SQL 2005 forum, I did the 2005 solution.
You can do the same thing with sysprocesses in...
November 8, 2006 at 12:26 am
Again, 5 users (5 different user names) or 5 connections? Is a single user allowed to make multiple connections to the database, and if so, do you count each of them,...
November 7, 2006 at 3:11 am
How many users, or how many connections?
For number of connections,
SELECT
count(*) FROM sys.dm_exec_connections
November 6, 2006 at 11:58 pm
Yeah, that will work better. Thanks. I overlooked the negating of conditions when I read up on LIKE
November 6, 2006 at 10:49 pm
If you define a data type as varchar without specifying a length, you get a varchar of length 1, hence all that you have in your variables is '1'. It's...
November 6, 2006 at 5:09 am
IsNumeric will work, but it will allow through some character data
SELECT
IsNumeric ('125D256')
November 6, 2006 at 12:12 am
Nope, sorry. You're going to have to get used to typing.
You can get management studio/enterprise manager to generate an update statement for you that at least has the full list...
November 3, 2006 at 2:24 am
Make the column an identity. Let SQL worry about the next number.
If you do increments yourself, unless you're very careful with transactions, you could end up with duplicate values (or...
November 3, 2006 at 2:16 am
See if you can get hold of the SQL Server 2005 upgrade adviser. It's probably available for download from MS.
With the testing I'm doing for upgrades, it's not so much...
November 3, 2006 at 12:13 am
What does the execution plan look like with the isnull and without it?
If it's a stored procedure, it may be getting a bad execution plan. If the optimiser compiles for...
November 2, 2006 at 11:32 pm
My main server has 2 heavily utilised large databases and a few smaller, less used ones.
We split the biggest database into 3 data files and put each one on a...
November 1, 2006 at 11:52 pm
Is there any trigger on the Address table? Are any errors been raised?
Are you using a cursor for the Address update as well? If so, I may have an idea...
November 1, 2006 at 10:55 pm
Could you please start your own thread for this. You'll get more replies and reads than if you hijack another.
November 1, 2006 at 3:47 am
Viewing 15 posts - 48,961 through 48,975 (of 49,566 total)