Unfortunately the software designer needs to take into account how many rows their queries can/will affect. SQL Server, in order to preserve data integrity, will put every record that gets...

Tobie, build times of what?

Thanks,

Chris

This is not an orphaned user problem, as the SIDS match. I just found some more info and typed about 2 pages worth of information about what I found, but...

I do so agree with the article, and wish that others in the community, namely those creating applications (that use databases) to sell. For instance, PeopleSoft. PeopleSoft told me that...

I just ran into this yesterday, and could not get a count for Null values if I was using the field with the Nulls in it for the count(), regardless...

WHY CAN'T NULL = NULL?????????????

That has always been my biggest problem in dealing with Nulls. Null does equal Null in the real world. If Null = the absence of a...

OK, nevermind, I have worked this out.

I do have control over the table design, and the user has now said that they would rather have a Null instead of the...

Unfortunately I cannot see a way to make any of these solutions work. The main problem, even with breaking the script up into steps which are procedures, is getting the...

The problem I encounter with sp_AddLinkedServer is I cannot get it to actually execute without a batch separator, and the batch separator kills all my my variables.

I'm beginning to think...

Perhaps "Jet.OLEDB.4.0". This is an Access driver, not a SQL Server driver. Your linked server will need to be recreated to use a SQL driver.

Chris

Depends on what you are trying to do. Visio, and Erwin allow you to create a pretty graphical representation, and even generate the DB or scripts to create the DB.

I...

It isn't. I have never installed SQL Server or a service pack under any account any part of SQL Server runs under. You need to have an admin-level account to install...

Any chance the original user's permissons were DBO or some kind of admin role on the server? Was the original user the owner of the database?

I ask all of these...

Remi,

What you suggested about is actually what I am doing now. I join my update query to the destination table and then compare the source and destination fields for inequality...

Thanks for the reply. I used some of your suggestions and did some calculations to find that I wasn't waiting long enough for the query to complete, by about 15...