I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were taking and that I understood the...

I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were taking and that I understood the...

Good luck, Wayne. Remember, it's just a job.

The uninstall, AFAIK, doesn't remove data files or things in the registry that might be used if you reinstalled. If it's not in the Control Panel or Cluster Adminsitrator, delete...

I would think this is the DDL to create a procedure. If it's suspended, maybe the network link got shattered and SQL didn't close it out properly? Can you kill...

I'm sure you'll enjoy it. Feel free to stop any of us and say hi.

You'd have to cast it out, separate the parts, get the totals.

So for seconds

cast( substring( cast(run_duration) as char(6), 5, 2) as int)

You can get minutes * 60 (for seconds)

cast( substring(...

restorehistory - http://msdn.microsoft.com/en-us/library/ms186782.aspx

How did you change the settings? In SSMS and the current settings are not shown?

If you check sys.database_files, what do you see in there? zeros?

AFAIK, no other benefits. both use the log, write transactions in two steps. The only benefit is to handle recovery with something other than a full backup.

If you run SQL 2000 and SQL 2008 as separate instances, it's like they are on separate computers. There is no integration between instances.

you can upgrade your SQL 2000 databases...

Be careful of the functions in your queries as they might cause performance issues.

If you only want certain tables, replication is the only choice. Other options will move all data/tables.

Be sure that you are not moving information that might be a security issue....

By creating the user, you give them access to the database. However that does not give them access to any objects (tables/views/stored procedures).

For that you need to give rights to...

Then I would script something. You can use the Windows Scheduled task to run a VBScript as

cscript.exe myscript.vbs

as the command. You can set up loops to run through all...