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

We have a Compaq SAN for some other items, but not the dbs. I have spoken recently to MS on another issue, a server with fiber channel disks, and they...

Slightly confusing, so let me state this simply and let me know if this is correct.

MAchine1 - SQL Server 7 server, has dts pacakge.

Machine2 - Remote Windows server machine containing...

No replication. Not sure why the values are creeping up, but pinged McAfee on the issue.

I suggested BIGINT, but since it's a 3rd party db and software, hestitant to do...

The "restore earlier log" means you are restoring out of order. Logs MUST be restored in the order they were taken.

If you are missing one, you can only restore to...