Morne,

SELECT INTO is used when the table does NOT exist. SELECT INTO creates the table based on what the SELECT returns.

-SQLBill

These are subselects:

(SELECT UID FROM dbo.GetSpecifiedSlumpInfo(P.RegionID, TD.SpecifiedSlump)) AS UID1,

  (SELECT UID FROM dbo.GetSpecifiedSlumpInfo(P.RegionID, TD.SpecifiedSecondSlump)) AS UID2

and as subselects, the alias' don't exist. Spell out the tablenames in subselects.

-SQLBill

Whoops...it looks like first you have to set up that group in Active Directory, then you need to add the group to you SQL Server logins (Security>Logins).

-SQLBill

This is from a referenced KB article:

Set Up the 2000 Compatible Access Group in the Active Directory Users and Computers Snap-in

By default, the Everyone special group is a...

Which night do you really mean?

Your subject says Wed night, but your text says Thurs night.

-SQLBill

1. Set up separate maintenance plans for each database.

2. Set each step to "go to next step" upon failure.

-SQLBill

<quote>Yes, the column name is "date",<end quote>

What database are you using? SQL Server doesn't have a "date" datatype. Datetime, but not Date.

Also, it would help if you let us know...

Or try:

SELECT CONVERT(VARCHAR(20), SERVERPROPERTY('ProductLevel')),

CONVERT(VARCHAR(20), SERVERPROPERTY('ProductVersion'))

-SQLBill

No. The transaction log is 'flagged' to go with a specific .mdf (data file).  The headers won't be the same. Log files use a LSN (I believe it stands for...

The question WASN'T "can you run it"....the question was can you run it on a 64-bit machine. No, you can't.

(BTW- there is a forum for the Question of the Day,...

Check out the 'undocumented' stored procedure sp_MSForEachDB.

You can do a search on this site for it and get descriptions of how to use it, or just look it up in...

I do 2 year archives.

I save all of the data to tape, then remove (delete) any data that meets the requirement for removal. Then I properly mark the tape...

You are out of luck.. You need a full backup to be able to restore a Transaction Log. There's no 'native' way to read the transaction log, you need a...

It sounds like you have an orphaned user. Look up orpaned user in the BOL and they describe how to solve this issue.

-SQLBill

Scott,

It's poor security to post your actual login and password. Especially when you post your server and computername. While it's already late, click the edit button on that post and...