I started playing with the fuzzy grouping. I like it.   I put the output in a spread sheet and let the users go...

Well, there isn't any fissionable material but a large cloud of Chlorine gas would produce similar results with the added benefit of not destroying buildings, infrastrucure etc

Thanks again - I am just starting to read up on the script comp. I originally thought of error output because it was simple. I need to identify the duplicates...

The error columns are not being populated. I have tried creating new packages on different servers but get the same result.

The main issue I see with pushing the rows...

I know very well how frustrating is. I spent a few days trying to fix what I was believed was wrong. I thought the time would be well spent since...

Unfortunately, welcome to the club. I found in a blog by a Microsoftie that said MS won't be doing anything with the this in the 2005 edition but will "probably" addresss...

I know a lot of people with "micro" businesses (1 to 5 employees, typically family) that use Access exclusively. They don't need anything more and it's a complete environment. My...

Tables in msdb:

restorefile

restorefilegroup

restorehistory (backup_set_id is in this one)

From the ".cab" externsion, this is probably a cabinet file. WinZip should be able to extract the file(s) in the cabinet. I think you'll find a database backup in there...

The users need to be a memeber of the DatabaseMailUserRole database role in msdb. 

IN BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/14cbf88f-d9d1-41a5-994e-532e2973ac9e.htm

To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb...

You'll need to turn on a couple of trace flags - DBCC TRACEON(3605, 1204)

These will send the deadlock information to the SQL Server Error Log and will tell you the...

You can use the Scripting Object in DMO (2000, 7.0) or SMO (2005). DMO can be use in a VB Script but SMO needs VB.Net.

Create your script/program and schedule it...

I believe it is only in the Script Wizard options when you click at the database level. Right click a database, Tasks, Generate Scripts... This starts the wizard.

I found this article when I trying to resolve a deadlock issue:

http://www.code-magazine.com/Article.aspx?quickid=0309101

I have a similiar problem. I am trying to use the Transfer SQL Server Objects to copy all tables and data from a source server to a target server. It fails...