I think the role of the dba is certainly safe for long time to come, I think it will have to evolve to deal with the issues that happen when...

The problem is a standard security one, if you own the box (i.e. you are an admin) you can do what you like. In the case of sql you...

how about sp_helptext 'sp_who2'

a database / os hybrid? You've just invented an AS/400! 🙂

not quite that advanced, visio 2003!

Hi,

Thanks for the comments!

greggoble2 - your right using the transfer logins task can definitely help here.

tushkieeeee - unfortunately you can't mirror a sql 2000 instance, you can go from 2005...

Hi,

Have a look here for how to run a package programatically:

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

-or- you could just call the DtExec program, use System.Diagnostics.Process.Start("c:\program files\...\DTExec", "Params")

ed

Hi Mark, The process is pretty straight forward.

The thing that really helped was getting backups restored on the new server and getting a test copy of the site working with...

Hi Eric,

To confirm which file (and whether it is all being read or not) use process monitor, (http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) and setup a filter on the filename and re-run the...

-or- go to a sql 2005 standard (make sure it is the same version / sp) and export the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\checksum

(if your instance isn't MSSQL.1 change it to...

and which version of sql...

can you upload a copy of the stored procedure and file?

There must be quite a few different ways to do it, you could schedule it and have a script task in ssis decide whether to run - or every year...

Hi Win,

What is the actual problem, are you getting high cpu usage and / or slow queries??

Can you detail the problem, when it started or if it has always happened?

The...

I am not sure why the sequence column would say n/a.

If you go to the "Options" menu the "Select Columns" it might be setup differently, just add the columns you...