My answer to someone that says, "Give me the same rights as user X," would be, "No. Tell me what rights you need and I will give you the appropriate...

You want to keep everything separated between the two databases. You certainly don't want a mechanism that automatically updates the production database with changes made in the test/dev database. Everybody...

And not to mention that if their triggers fail, it can cause your transactions to rollback.

In fact, if memeory serves me correctly, I think it was new in SQL 2000 SP1.

Personally, I have had failures when trying to create a backup to a UNC share on large databases (not to mention it took a lot longer). The backups created on...

The 2 most logical options seem to be, in my opinion:

1. Use the sp_OA.... (OLE Automation) procedures to create an instance of the XMLHTTP object to access the page and...

Then i would check the collation of the columns of sysobjects itself.

Select

c.*

From

sys.system_objects o

Inner

That's only available in Analysis Services.

I run the whole thing as a single transaction, and my connection isn't released until it completes. It has never failed for me when running it as a single transaction.

Are the values embedded in the hyperlink (i.e., http://www.mysite.com/Myvalues.html?Myvalues=2,3) or do you have to open the page and then it outputs 2 comma delimited values?

If the first, then just...

That's why I said do it all in one fell swoop. I'm using the database, so if anyone else tries to become a user, they are blocked.

Use a self join. A self join is when you join a table to itself.

To see all of the rows considered duplicates:

Select

Copy1.*

From

MyTable...

I think that first you need to identify what part(s) of the process is slow. Is it the Select of the data, the insert of the data, the re-indexing?

When dealing...

You can back up to UNC paths as opposed to a "local" drive, but I wouldn't suggest it.

There are lots of ways to do this. Exactly what are you trying...

Check out the MS KB article on this: http://support.microsoft.com/kb/909380

There is a hotfix available.