just guessing here, but i'm thinking you upgraded your server AFTER you created the backup, and system databases are restricted tot eh same version...client databases can be upgraded on the...

another testable example, based on sys.objects:

SELECT name from sys.objects

order by CASE

--crap with an underscore at a certain position

--gets banished to the bottom

WHEN SUBSTRING(name,3,1) = '_'

THEN 2

ELSE 1

END,name

i think you just need something like this:

SELECT BL = CASE

WHEN Business_Line IS NULL

...

page number is the exact same logic, just handled like this:

ALTER PROCEDURE GETSOMEDATA(@PageNumber INT)

AS

BEGIN

SET NOCOUNT ON;

declare @increment int

SET @increment = 10

...

a lame example:

CREATE PROCEDURE GETSOMEDATA(@Start INT,

...

can't you easily see the credential_identity column from select * from sys.credentials?

why do you want to rename the name column if the credential_identity column has the...

I don't use TOAD, but i do some Oracle conversions a lot.

i thought ALL concatenation in Oracle must use double pipes...why do i see you trying to + strings togehter?...

thanks drew!

I'd hang my head in shame for not knowing that but since it's outside of my typical comfort zone, I don't feel too bad.

That cleared up my query really...

that's kind of vague; did you get an error due to permissions, because you didn't have priviledges,...

example of what? an insert with newid? the way i would do it?

you'll need to provide a lot more details, i think..what table DDL do you have so far? what...

the newid() function and the datatype uniqueidentifier for the column data type is what you are looking for;

you can make it the default value of a table, but...

OK i've played with something similar..i wanted to orgianize data for a web page into 5 columns, instead of one increadabily tall column of data for a web page.

here's...

i'm not an expert in xml(yet), but i fiddled with this before:

I'm assuming you mean you have an NVARCHAR dynamic SQL thing going on?

this is getting all the plans in...

yep...seems to go back to...

You'll probably want to show us the specific proc you get the error with.

you also want to show the specific error you get.

anyway, since it is an error in...