...and is supported by Microsoft.

Also, SQL Server Personal Edition, and of course MSDE, also install and are supported by Microsoft.

This is also a good reference for DB2 SQL that I keep bookmarked.

https://aurora.vcu.edu/db2help/db2s0/frame3.htm

Sounds like the remote client is holding on the session after it's work is done.  The RPC session can drop due to inactivity, the client doesn't know it, and tries...

You also want to consider that if the data is encrypted/decrypted at the database server, then the data is transmitted over the network as unencrypted, both ways.  Especially if you...

No, it really isn't needed.  SQL Server backups to disk, then backup the backup files to tape.  That provides the fastest and least impact on performance. (While a backup is...

...or do you need 200 CAL Licences per server?

No, a CAL license covers any and all SQL Servers in the enterprise.

...we will also need to buy 3 Server Licences?

Yes.

...We would...

Actually I was called into a client's site for that same problem.  Turned out that they had just recently implemented disk space quotas on the server, and the domain account...

You have, of course, checked that your connection string has userid and pwd parameters in it, and does not say "IntegratedSecurity=SSPI", right?  If it has that, even if you do...

I guess you must be able to create partitions on different drives, I'm still wondering how to do exactly that.

Sure you can.  But it all depends on how the raid...

If taking the single quotes out creates an error, then the data type must not be integer, it must be char or varchar.  So are you getting an error trying...

I'm still fuzzy about why an excel spreadsheet would need any credentials...

Accessing any resource (and a file is a resource) needs to have an account to determine security and permissions. ...

Perhaps a file access security problem?  What security logon is the linked server using?  If you used default Windows Authentication, does Tina have permissions to access the file?  Or you may...

Did you try eliminating the single quotes around the UserID in the SQL String?

strUser = strUser & " WHERE (User_ID = " & receivedValue & ")"

instead of

strUser = strUser &...

You are correct in that putting data and log files on separate partitions of the same drive or drive array gains you no benefits over putting them on the same...

I had done this for a client once.  I used vbscript and SQL-DMO objects to do the "Generate Script" functionality.  (I beleived I had used the GenerateSQL method of the...