Read this, it would indicate a metadate error

http://www.sqlservercentral.com/articles/Corruption/65804/

this article links to this

http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Using-the-SQL-2005-Dedicated-Admin-Connection-to-fix-Msg-8992-corrupt-system-tables.aspx

Paul Randal is the man. He wrote DBCC CHECKDB, I would treat whatever he says as gold.

Have you run an integrity check?

can you post your script?

It seems that instead of a linked server you need a shared folder

in your script you would have the restore be

RESTORE DATABASE [DATABASENAME] FROM DISK...

Hey Trooper,

Sorry I'm a little confused, are you restoring from a prod backup.

Or importing data from a prod database to refresh your dev?

...

GilaMonster (5/14/2010)

---

Shivrudra (5/14/2010)

---

In MS-SQL Server all DML statements are:

1.Auto committed

2. Need to be committed with commit command after transaction.

3.Each DML must be preceded with BEGIN TRANSACTION

4...

I have nerver been able to get it to work like that.

I have this script that I just posted for Lucas in another thread. I use this to delete...

Steve Jones - Editor (5/14/2010)

---

Integration Services has OLEDB drivers to connect to other sources. If you can make a connection from the Windows machine to MySQL, you can build a...

Do you have the ODBC connection installed on the server for MySQL?

you will need to create a linked server to the MySQL DB

I have a MySQL DB I import from...

sorry didn't read the whole thread before I replied

yeah too bad your not on 2008, you could completely limit them with resource gov.

you could write a procedure that would load...

I have a postgreSQL box that I'm migrating over to SQL, and I have several MySQL that I have to work with.

I would agree with everyone, SQL Express will be...

Hey Lucas to check for file type I added the code to check for the last four characters on the filenames. What I edited is below.

delete from

@myTable2

where FileNames...

No worries Lucas Happy to Help!:-D

Can't answer for him, but based on what he has posted I would say no.

He's working with 9.0.2047 the SP 1 RTM release number

http://sqlserverbuilds.blogspot.com/

Lucas if it gives you any ammo,...

Hey Lucas,

That should not be possible, the dir command just looks in the directory that it is specified to. this will not work against sub...

Filegroup Backups and Restores

When a Database has multiple filegroups you can back the database...