I'd post some more information under the DTS forum and we'll try to help. Or under the replication section.

Steve Jones

steve@dkranch.net

Ahhh, then I agree ().

I'm usually for SQL Logins, they are easier to deal with and it's easy for NT permissions to get out of hand in...

I've done this, but populated a table with the valid business days. Then sum this up. Don't forget that holidays can be business or country specific, so accounting for this...

Sorry, I midread. the instances threw me.

Try running SQL Setup and choosing "Rebuild master"

Steve Jones

steve@dkranch.net

as andy said, create a batch or .CMD file. In it do a "net stop mssqlserver" and a net start mssqlserver (or whatever the service is named).

The NT AT or...

Haven't seen any issues either. Can you give us some more info (browser, os, versions, connection, etc.)

You can email if you do not wish to post (sjones@sqlservercentral.com).

If you have issues,...

Cheapest I have used?

I use my pushFTP process to move the database backups every 15 minutes from production to the QA server. Once a week I restore the QA server,...

I think these must be set when the link is created. Can you edit the link (sorry not that familiar and too busy to dig through it).

Steve Jones

steve@dkranch.net

AllyAnne,

NT Auth is nice in that the DBA group can be managed as it applies to the entire group. There are no password changes here either. If you use SQL...

If they are the same server, then you have a problem. The SQL3 server sees master as c:\mssql\data\master.mdf (or something like this). If you then restored this master on the...

SQL Server will not release the memory once it has allocated it because it expects that it will need it again. If you start other tasks on the server that...

Thanks for the followup. I'd run a full checkdisk( requires a reboot) and make sure you have no low level issues.

Steve Jones

steve@dkranch.net

Why? I think you need to restore the standby back to what it was. I didn't think that the master database went in a restore (in general). The server name...

Tend to agree about format and fresh install. Too many things to break in an upgrade in place.

Steve Jones

steve@dkranch.net

I think you misposted. Users need and should have access to a database. Otherwise, what is the point. Not all apps can use stored procedures. Even if they do, a...