Does your business logic require that g in T3 only contain values that match those in T1 field a?

Or is it OK to have values in g in T3 that...

I don't think your being harsh, Antares686, simply pragmatic, and quite honestly, I watch for responses to posts I have made to see what others have encountered that maybe I...

You can change the database name with the stored proc in master sp_Renamedb

or Use the ALTER database statement....

As for the procs, I script them all out in a single file,...

I saw a similar situation at a job before. We Upgraded to an eight processor machine, and the database performance degraded by 60 something percent. (We always compared to...

I'm thinking that Allen has the better solution. If I understand szopdog correctly, he does not want to delete todays records, but everything less than todays records.

Steve's answer would...

Now thats an age old debate.....

Where should VB stop and SQL start?

Do some research on application design models. Over the years, the opinion of whats "Best" has changed dramatically.

There...

I agree with nickel01. Triggers have their place, but I don't believe thats one of them...

I perform archive and cleanup functions through an hourly job (requirements from business logic make...

Depending on how these codes are used, how often, and the size of the combined table, it could possibly:

increase concurrency,

reduce overlapping IO calls,

and reduce indexing needs by...

Another approach, would be to use a single proc, which grabbed the client data and task data as a recordset, with one switch, and updated / inserted with another. However,...

The scenario as I think about it would be closer to:

The person table would be populated with all your person data from the start.

The Data access page would get the...

Had this error a few months ago....

Here's what I found, and it worked for me...

sql server enterprise manager general ole error 16386

solution:

a. Stop all SQL Server services (MSSQLServer, SQLServerAgent, MSSEARCH)

b....

When installing SQL Server 7 and 2000, there are optional developer code sets that contain examples similar to what you want.

Of course, now that I think about it, I use...

I always use stored procs for things like this. It may be old school, but it never fails me.....and much more cross platform compatible, too.....

Ahhh, makes good sense....

Our web servers do all the access, and use pooled connections, so its not on an individual basis. We handle all that through application logins later. Ours...

I have never believed there was a such thing as a dumb question, though I get flamed on a regular basis for what people tell me is a dumb question....