Instead of dropping them one at a time, try renaming them one at a time.  Then after a certain time period you cound drop them.

Steve

You could have a working SQL-Server database created to take the results of your queries and have a generic Access database name that your dts runs against to dump data...

I have a script that creates a stored proceedure for documenting tables and columns.  It uses the extended properties for the table and columns as descriptions.  I then take the...

Here is a link to methods of upgrading and 7.0 to 2000 and addresses issues of logins and orphaned users.

http://www.sqlteam.com/item.asp?ItemID=9066

Steve

I've migrated from Informix On-Line on a Solaris machine that used 4gl to SQL-Server.  What are you trying to convert: the tables, the SQL queries, the forms?

I've used both bcp...

Just a thought, have you tried dropping the user from the database and then adding her back?  Sometimes there is a disconnect between the Logins setup for SQL-Server and the...

I'm sorry.  When I say workaround I mean implementing syntax that is not obvious (undocumented) or intuitive (WITH CHECK CHECK does seem a little unusual) to solve a problem.  I...

Thanks for the work around. I will try it out.

Steve

I have no clue what SAGE is, but is there a way to reverse the process from SQL-Server to SAGE and then compare the original to what you sent back?

In...

A word of caution, make sure you are doing this on varchar fields and not char.  char fields always include trailing spaces to the defined length.

Steve

Chrislis,

let me know when your script is published.  I'll take a look at it.

Steve

Actually, disabling and re-enabling foreign keys is the easiest way to go.  I actually came up with the script because Red-Gates SQL-Compare has a bug in it that doesn't recognize...

I have a script that will generate the Dropping and Recreating of Foreign Keys in the Script Library for an entire database.

http://www.sqlservercentral.com/scripts/contributions/1530.asp

Steve

Do you have Check Database Integrity on the Integrity tab checked?  This will increase the log size but I don't remember if it increases the database size.

Steve

I have a stored proceedure for deleting old backups.  You will have to adjust the naming convention to work with maintenance plan standards.  You might also be able to use...