In production, avoided. Though in my world, with dozens of servers, we have to let some people manage their db while we manage the server.

In dev, I try to avoid...

I've got a review coming out next week or the following.

I spoke with the Litespeed people at PASS and they mentioned that they had worked with MS and taken advantage...

Does this happen from multiple workstations? Try to narrow this down between the workstation and server.

If it's the server, if you can, detach dbs, uninstall, reinstall, then attach dbs.

If...

I actually mentioned this on a PSS call and they mentioned it has something to do with the SQL Server being unable to validate your credentials with a domain controller.

We...

Very interesting. Course, be sure you protect the backup files as well. Especially when they are on tape.

For laptops, we use Pointsec (www.pointsec.com) here at JD Edwards. Help Desk has...

That will work as well. Thanks for the script.

Steve Jones

sjones@sqlservercentral.com

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

The VB program should be running under the context of the user who executes it. This is the account that needs to execute DTS and log into SQL Server, and...

http://www.sqlservercentral.com/resourcecenter/sqlmail.asp

Steve Jones

sjones@sqlservercentral.com

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

bcp is your best bet then.

Steve Jones

sjones@sqlservercentral.com

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

I have both, not sure which is better. Good and bad, only using XP for about 6 months.

For SQL developemnt, not sure it matters. The interface is the same and...

You have to drop and recreate the table. You can make a new table, move the data, and then rename it (after dropping the old table). This is what will...

I think you can use WinZip after you detach the file and span this across disks.

This is, I assume, for transferring this db to a client or somewhere else. If...

You cannot "recompile" a table. You drop it and recreate it. You can alter it.

Can you post the code you are trying to run?

Steve Jones

sjones@sqlservercentral.com

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

Is it every time you reboot? So if you shrink and then reboot, does it immediately grow?

You might also try detaching the db, then reattaching with no log. Do a...

That's a good idea. Not sure how much participation we would get, but perhaps worth implementing.

We're upgrading the forums, so it would probably be after that, but we'll look at...