Without seeing the errors, it is hard to help you.

I usually use the synchronization feature to make a copy of a database on another server. You may want to...

If you application works in a disconnected mode and re-connects when it needs to get data or make a change, you are done. If you application retains an open...

That option is in the "SQL Server Destination" component. Are you using an "OLEDB Destination" component by accident?

Make sure you are on the latest service pack for reporting services. MS changed the print dialogs a couple of times - I cannot remember if it was in...

No. Most undocumented procedures seem to live for awhile.

It is really an indication that they may remove it, rename it, or change it without telling anyone. There have...

And if you post again, the large font you have used is pretty annoying.

I am not sure why you think this is a nightmare. In SQL 2000, a GUID as a primary key was fine, it usually is bad for a clustered...

The answer is no. You have the same chances of generating the same GUID if the column is in the same table or different tables. The table the...

Lots to add here.

First, on the licensing - you can install the Development Edition of MSSQL on a server as long as everyone connecting to it has a developer or...

Search around this site a bit, I have seen this problem posted before.

I think the issue may have been the server service pack level being different than the client tools,...

The update is going to update every row in which any column happens to have a NULL. If the table is large and you have even a few columns...

Also, you want to make sure you are not creating a clustered index in an order in which adding new data will fragment your index. If you do, it...

If you are using SQL Authentication, there is not much you can do. You can trace the login events, but most parts of a connection string can be modified...

There is a command-line utility for deploying DTSX files to an integration services server (and to do lots of other things).

The command will look something like this:

[font="Courier New"]DTUTIL /DestS "%SSISServer%"...

You could create an alias on the client end that specified TCP/IP.