If you are referring to an database role, yes we do have such a role set up.. and all the db user are added to it. I left that...

Bruce:

With the user example above,

select system_user as [system_user],current_user as [current_user],user as ;

returns:

"TEAMWORK\akruesse" , "DBO", "DBO"

Desired value would be "Agnes_Kruessel"

If you Windows login and database user name are the same...

By "sysadmin group" are you referring to the user's membership in the "Planners" role, GSquared... and Planners' ownership by dbo?

If so, is there anyway to alter the Planners role to...

There don't seem to be any other export options. Every format I try except XML exports the controls codes as text.

Table2 and Table3 each have 3 column datatypes in them that Table1 does not:

"varchar(max)" (table2 has 2, Table3 has 6)

"char" (table2 has 3, Table3 has 3)

"decimal" (table2 has...

This looks promising, jsheldon. My Thanks!

Keep in mind that the legacy server is not a true Sybase engine, but rather the Sybase SQL Anywhere (SQLA) product, formally known as...

It's a mystery to me how SQL Server is not set up to handle what in our view is a basic necessity (namely: "when" was the record last updated, and...

Applied:

EXEC sp_dbcmptlevel 'SPLINT'

returned '80'

Ah Hah!

Applied:

EXEC sp_dbcmptlevel 'SPLINT', '90'

That did the trick! Now I'm good to go.

Figured it had something do with that fact that it's legacy db.

Many...

Thanks Jack:

I applied the following:

use master

ALTER AUTHORIZATION ON DATABASE::SPLINT to sa -- "splint" is my errant db name

No change in behavior. Same error msg.

"Ckeck out BOL"?

Thanks SQLBill:

I applied the following:

use splint -- "splint" is my errant db name

exec sp_changedbowner 'sa'

No change in behavior. Same error msg.

Should I restart the SQL Server?

Are Diagrams...

I imposed myself on your script, George, after getting a few error msgs (see below).  Note that I added the three selects to the SP, which means that tRolemember could...

Those work for me, Aaron.

I extended both versions to the following in order to determine both the Day's beginning and end datetimes:

select CONVERT(