Thanks for the reponse. I've later found out that our IT department has sent some people to training at Spindustry here in Des Moines. Heard anything good, bad...

I've been trying out SS 2005 Developers Edition and did not have a default instance. I did run into a problem when I was trying to check out running...

I had a similiar problem from my replication that was set up with a different machine for Publisher and Distributor. It had been working fine and all of a sudden...

Please tell us where you are located. Chances are that there is a SqlServerCentral poster near you that could help or know someone that could help.

Steve

dbo is not a specific user. When a user is a member of the System Administrator Server role (sysadmin) or the db_owner database role, any table they create is...

I don't see any point in trying to go to 2000 Standard before upgrading to 2005 Standard. Your question should be "Can I upgrade from 2000 Enterprise to 2005...

Just to confirm, when I was hired at IBM I was told that they used to hire music majors for programming jobs before there were comp sci majors.

I played clarinet...

You must grant individual users access to a particualar database. Logged in as sa, from Enterprise Manager, go to Security - Logins. Right click the user you want...

If you believe that you can get a list of social norms so that you can seamlessly fit into a different culture, then I think you will be sadly disappointed....

You might try renaming the tsyncobj ables for a time and see if it causes any problems but I don't see why it should. The sp_MS tables are created...

Steve,

This would only occur for a specific login (not the intended end users) and would be used by an administrator to refresh the database for the current needs.

I could see...

My co-worker is setting this up and replication looks like it is going to work. He is setting it up to use Windows Synchronization Manager to pull down the...

Setting a limit to the size of transaction logs is not the way to keep them under control. As you have found out, this just results in the database...

The only place I've seen that upper cases everything is an Ibm Mainframe. I have some files that are copies of that data so I keep that data upper...

Some of the advantages of using windows accounts:

- Windows accounts can force password changes on a regular basic

- You don't have imbed passwords in programs or force users to enter...