Use Enterprise Manager, expand down to the database. Right click on the database and select Properties. Go to the Data Files tab. What do you have set for "Maximum file...

swede,

The database does not need to exist on the new server for it to be attached. I have done this several times.

koithodan,

The problem is that you never detached the original...

dnivrav and gfahrlander,

Even though we've gotten off the original topic and this should have been in a new thread....check out this article:

http://www.sqlservercentral.com/columnists/bknight/10securingyoursqlserver

-SQLBill

That's correct. You would then need to create a login for them and give them the access they need. It won't be automatic.

-SQLBill

Something like this, you'll have to work with it:

SELECT

CASE WHEN DATEPART(dw,getdate()) = 5

THEN <code>

...

Also, check the SQL Server Error logs (In Enterprise Manager drill down to Management, expand that, expand SQL Server Logs and double click on the most recent one).

And also check...

According to the Books OnLine (BOL), the transaction log backups apply to the last full backup.

Refer to BOL, use the Index tab, enter

transaction logs

double click on 'backing up'

Select the option...

dnivrav,

Builtin/Admin is a poor security practice. It allows ANYONE who is an administrator to have SYSADMIN access to your databases.

Let's say we work together. You are the DBA and I...

Typo on my part. There should have been a comma after the first DAY in each line:

WHERE Due_Date > DATEADD(HOUR,0,DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE()),0))

AND Due_Date < DATEADD(HOUR,0,DATEADD(DAY,(DATEDIFF(DAY,-1,GETDATE()),0))

-SQLBill

Are there any error messages? In Enterprise Manager,drill down to Management, expand that, expand SQL Server Logs. Double click on the most current log. Also, check the Windows Event Logs.

Next...

I believe it has to do with SCOPE. Refer to the Books OnLine (BOL) for Variables and select the option for Transact-SQL, then search for scope.

BOL talks about how a...

There isn't any IIF in SQL Server. Use the CASE statement.

-SQLBill

We use TCP/IP.

This is from Inside Microsoft SQL Server 2000 by Kalen Delaney.

quote:

---

Microsoft internal testing has found the TCP/IP Sockets Net-Library...

Each maintenance plan creates a job. In Enterprise Manager, drill down to Management, expand that and expand SQL Server Agent. Click on Jobs. Find the maintenance plan job, right click...

It designates UNICODE.

-SQLBill