Did you see this thread from yesterday? http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=227694

Greg

I've seen lots of methods for executing a DTS package from a stored procedure or an ASP page.  You can use xp_cmdshell & dtsrun, OLE stored procedures, or set up...

You can use xp_getfiledetails in an Execute SQL task to get the properties of a file.  I don't have the details handy, but you can search this site for references.

Greg

sp_who returns info about users and processes connected to SQL Server.  It's in BooksOnLine.

Greg

See this site for an example:

http://www.sqldts.com/default.aspx?215

Greg

This seems like a situation where a database comparison tool would be handy.  Red-Gate SQL Compare, Quest Comparison Suite, ApexSQL Diff, et al.  I use ApexSQL Diff to compare objects...

There are several options.  You can use the Copy Database Wizard, backup and restore, or detach/attach.  This article has the details: http://support.microsoft.com/kb/314546/en-us

If you definitely want to copy the databses,...

It occurred to me that you didn't mention when or how often you do full backups.  Are those going to different backup files than the log backups?

Greg

If you mean you want to find the members of server roles, use SP_HELPSRVROLEMEMBER.

Greg

Cecilia,

The job description is a bit confusing.  SQL Server administration is the first item listed under Responsibilities, yet the Required skills and background lists only Oracle knowledge.  Additionally, you posted in...

The first backup of the day (9:00 AM?) should use WITH INIT to overwrite the backup sets and start fresh.  All other backups during the day should use WITH NOINIT. ...

To prevent other connections once you've killed existing ones, you could restrict access to the database going to the Options tab of database properties in Enterprise Manager.  Check the "Restrict...

You'll get a 'database in use' error and the detach will fail.  You must have exclusive access to the database to detach it.

Greg

The "prefix" is the owner of the object.  If you're not sysadmin of database owner, it defaults to your user name unless you specify another.

To fix, run this for each...

We've used Lumigent Log Explorer for about 3 years and it's worked well for us.  We recently increased the number of licenses and got a discount as a continuing customer. ...