Scot,

You say you logged into a SYBASE test system. This question is for Microsoft SQL Server not Sybase, the two may not (and probably don't) work the same way.  That's...

Does your SQL Server services have access to the network drive? Right click on the My Computer icon, select Manage, expand Services and find what the SQLServerAgent and MSSQLServer services...

By the way, the style part of the CONVERT is only used when converting from datetime TO a string. When converting from a string to a datetime don't use the...

Shame about the problems you are having with the other site, but this is a Microsoft SQL Server site (even though there is a part of this site for MS...

SA24,

Good suggestion except for one thing. As I said we don't have trusted network for a reason. Specifically it's a security issue.

NETONLY doesn't exist as a command on our systems....

Also, what size did you orginally create those databases as? You may have created them as 2 GB databases. (In Enterprise Manager, right click on the database. Go to the...

Since you got a collation error with the equals part of the JOIN, I'm wondering if SQL Server is thinking that was a date.

For example: If I want to check...

In your original post, you seemed to have a question about the size of the master backup (but you post wasn't worded as a question - so it's hard to...

I think it's a personal opinion. I've never seen anything in writing that states what size makes up a small, medium, large, or huge database.

I have a 172+ GB database...

Ed,

For Windows Authentication to work across domains you need to have trusted networks. That isn't always available. My database is accessed by users in multiple domains and for other security...

SQL Server services use the default login of Local System. (Right click on the My Computer icon, select Manage, expand Services, find the SQL Server services and look at what...

Yes, you can't run either of those on XP.

Here's the information from Microsoft:

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:

• Windows Server...

No matter what authentication the SQL Server is set for (Windows Only or Mixed Authentication), Windows Authentication is always allowed.

The user's login must be specifically set to Windows Authentication.

You seem...

Do you create SEPARATE .trn files or are you APPENDING to the .trn file?

If you are appending, that's your problem. The RETAINDAYS and EXPIREDATE work by the date/time of the...

The issue here is how is the login and authentication being done? It appears the user is typing in his/her login and password (via Windows account). Once you give a...