I have not encountered this error. 

However, my guess is that since you changed the domain, reporting server can no longer connect to the SQL Server Report database.  You will...

I am telling you this off the top of my head, so syntax could be off since I am not at the office.

Edit the property and select "expression" for the...

I ported an application from mySQL to SQL Server.  The biggest problem I ran into was that mySQL is very type-loose meaning it can deal with coercion of type data...

Unfortunately, I think to get a fixed length text output from report server, you will have to write your own export extension.

In layman terms, imagine that you want to modify or update data in several steps.  However, should any one of those steps fail, you would like to revert your changes. ...

I think MS has a free web based db manager.  I'm not sure how good it is and whether it will meet your needs.  If interested in this, go to...

Take a look at using a merge or transaction replication, as well.  It may be a good alternative to DTS.

What may be troublesome are your external systems and having them...

Triggers do not monitor data.  They only run on table for an insert, update, or delete transaction.

Can you explain what the table holds?

Is it a table that holds a single row of...

Or, you can add a cascading delete option for the primary table Customer and Departments, but only do this if you want this type of action.  Otherwise, the DRI helps...

Jenney,

It's been a while since I have done work with replication.  However, I recall that the snapshot agent is simply a job.  So, you should be add to run the...

Check to see if you have any backup or maintenance jobs.

I had a problem once where sometimes an update job would die at 1:30am and never finish.  Other times, it did. ...

Does this error occur during an update or a select?

It looks like you are using ADO.  The one thing I hated about ADO (I use .Net now) is that errors...

Okay, but that does not address the issue at hand that we are arguing which is "why is it wrong to use an IDENTITY column as a primary key?"  There is no...

>> Yes it is; creationism versus scicnce

Once again, opionated crap.  Useless feedback.

>> Things are worse if you trry to ue an IDENTITY over...

Frank,

It's not that I don't value Joe's points.  The delivery of his points is packaged with a lot of vanity.  If you tear away the wrapping, yes, there are good...