session is single_user mode, or the database?

if it's the database,

you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who's...

npyata (5/2/2013)

---

Here is the code. This is my first step in the process and after this seq_no update I need to update some other columns based on this seq_no.

USE...

there are lots of other functionalities that SSMS assumes you must have sysadmin rights in order to perform actions;

most of the nodes in the Object explorer assume it, ...

thank you Gail!

they are the same query, but with a some expressions to calculate the field values.

test it yourself by looking at the actual execution plans when you run them.

they will both...

Tobar (5/2/2013)

---

Anyone have an idea why the varchar data type is limited to be 1 through 8000 or MAX(2GB) but none of the numbers between 8001 and 2GB?

Just one...

duplicate post.

There's no need to post the same question in multiple forums.

The Recent Topics function most people use shows us your post immediately.

crossposting will wastes people's time and fragments replies....

wow it's been a long time since i had to do this in SQL2000;

SQL 2000 doesn't support row_number() functions either.

if you can go without row_number, it just becomes a sub...

a slight modification if you are using windows authentication:

-- we need a login for the Web To Use:

CREATE LOGIN [DEV223\ASPNET] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

--pick the right db!

USE [WHATEVER]

--now we...

here's an example i adapted from another one I've used int eh forums here:

-- we need a login for the Web To Use:

create login WebUser with password = 'NotTheRealPassword'

--pick the...

In Oracle, Each Object can have double quotes. that means the table can have quotes, and it's column names can have quotes...but you can't wrap them all in-one..they each get...

You are looking for the BREAK keyword.

a simple example to break out of what would otherwise be an endless loop:

--RAISERROR immediate message

--print error immediately in batch

DECLARE

@i ...

you can join the table against itself, and use the modulus operator to limit it to the "odd" rows for the first value, leaving the second value as the date-ish...

excellent! glad we could guide you in the right direction; I for one am very glad you were able to solve this with just a gentle nudge!

ouch; remote-second hand assistance is tough,

I feel for you and what headaches are involved in getting your information once-removed from the client.