If the procs are only changed by dropping/creating then the following sql will show you when they were last created:

select name, crdate from sysobjects where xtype = 'p' order by...

If the user can log on OK by entering the SQL Authentication User name and password, the error must be in the connection string your app is using to link...

Not that I think its the cause of your problem, but I hope you haven't got a clustered index on that GUID. It could cause a large amount of data reorganisation every...

In Query Analyser, show the execution plan and client statistics for each query. Check that all servers are using the same indexes. Also check that the same number of packets and bytes are sent/received....

The BOL entry for error 644 says it is a non clustered index error - trying to delete a record that doesn't physically exist in the table.

You don't say if your...

You need to put the user password (usually "") for user id Admin in the connection string, not the database password. The only way I can think of...

I prefer using the following SQL that looks at what is happening in a 2 second period. It was posted by someone on this site but I can't remember who,...

You could also do it with openrowset() or make the access database a linked server. I have a nightly job that adds new staff members from an access table to my...

You should be able to use DTS. Put the free VFP 5.0 files on a folder that can be accessed by the SQLServer server. Then on the SQL Server PC...

I am not suggesting this is the best approach, but I have a little Dos batch file running on the live server, scheduled to run once a week. It stops...

I have not found any way to link to the access database from SQLServer if it has a password set using Tools/Security/Database Password in access. All the access methods work on...

Database 'distribution' is used to store settings for replication, if you didn't already know. Sometimes when you start to set up replication and then quit, it leave details in the...

Sorry, forget 2Gb. Old technology. I'm out of ideas. Repost this to see if anyone else can help.

While trawling for answers just now I came across a possible linked problem....

Set up the remote server as a linked server. Then you can execute the stored procedure using the 4 part name. For instance if the remote server is linked with...

Have you tried this backup splitting with a very small database. I have tried it here with no problem. If it works with a small or reasonably sized database then...