Satish,

You do not have to create the "inserted" table. SQL Server creates this temporary table itself to handle the data that pertains to your inserted trigger. You can...

One simple way of doing this is to create an archive table for your production table (Messages in this example), and set a delete trigger on your production table to...

It's good to know the dirty secrets of the application; however, you can get 1GB of ram for under $200. www.pricewatch.com

Is the purpose of your replication setup to have C and B synchronized, and you are using A as a "staging" database?

You can use the JobServer object to check the status of the agent.

 

Dim oServer As SQLDMO.SQLServer

Dim oJobserver As SQLDMO.JobServer

Set oServer = New SQLDMO.SQLServer

oServer.LoginSecure = True

oServer.Connect...

You might want to check your permissions on the tables, although if the problem is not consistent, then it might be locking, a network issue, or something out of your...

I agree with Andy as well... but am I to understand that you have normalized the addresses to the point where the city of Greenville will have the same ID...

You are correct in your assumption that they are conflicting. The way you have it set up, the update trigger is getting executed every time you do an insert....

I was unable to duplicate the error. I got the same error that Andy did when using QA in grid mode. I'll see if we still have an...

The server pause should work. You can do it programmatically through DMO, using the server object and its "pause" and "continue" methods.

Sean

You can identify the version of SQL you are conencted to through the Properties collection of the Server object (start by using the latest DMO to query the server).

You can use the SizeInKB property of the Database2 object to get a more accurate measure of the DB size. The Size property of the Database object returns a...

I'll run a few more tests. Let us know if you figure it out, or come up with any work-arounds.

Thanks for the feedback. It's important that we get the final outcome to these topics. Other readers find a lot of vlaue in knowing "the rest of the...

Do you care what the value of the data is? If not, one option (slightly more expensive) is the uniqueidentifier data type and the newid()...