Is this SQL Server 2000? If so, the restoring to other servers isn't a big deal. Can always attach files from whatever drive they are on.

As far as performance. From...

<shamelessplug> Brian's Admin 911 book is a good beginner place to learn about admin'ing SQL Server.

</shamelessplug>

For designing tables, it works similar to Access, though I'd grab any of the "application"...

Not really appropriate for the the suggestions forum. This is more of a Development issue.

Pls post there.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Not to play devil's advocate, becuase I get as annoyed as anyone with subject lines that don't pertain to the message. Same with cross posts.

However, the have been times that...

Use a maintenance plan.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

And you didn't have to tape anyone's eyes, did you .

Congrats and thanks for the hard work.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Actually more complicated, but basically when the account logs in, it gets a token with the SIDs that the user has associated to them (user + groups). These are then...

try select * from syscomments where text like '%suid%'

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I know the statement will be recompiled, but not sure about the procedure. Will try to test.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

There sure are some beauties. Wonder how many posts wouldn't have been made if it had been more correct.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

What happens if you restart the installation

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Need some type of NT/AD scripting to get this info. Not directly in SQL. Could use SP_OACreateObject to instantiate one of the group objects and query it. Not pretty.

Maybe Brian...

Need to query the len() of the varchar columns. Other data types have their precision listed in select * from information_schema.columns. Have to write something to sum up the values.

Steve...

Apologies for not dropping this sooner, but as someone else mentioned, they hadn't seen it either. I just heard about it last week.

We welcome submissions from users if you see...

Haven't had issues myself. If I get the debugger running, usually rights for the service account, I can easily stop at any breakpoint I want.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones