Yup, you would. It's the syntax for a common table expression (CTE), essentially a temporary view. The...

Likewise.

jsanborn (4/1/2009)

---

I'm not making judgements or trying to insult anyone's intelligence, but the sample I posted should be self explanatory. It's the people who can look at the example and...

I've just finished doing one for a client. It took me an entire week...

I agree with Jack. That's not right. It's easy for people to get a poster's history if they want to.

The file in question ('D:\MSSQL.1\MSSQL\Data\Academic Reporting.mdf:MSSQL_DBCC9') is al alternate...

Double post. Sorry

Restore from scratch each time.

Write a custom sync program or a rather complex SSIS package to do the same thing. This will have a non-trivial impact on production

Replication's the usual...

Are you running this in a job? If so, check the SQL agent permissions.

No need. It's trivial. Add WITH NORECOVERY to all of your restored. However that means that the...

Check the permissions on the directory D:\MSSQL.1\MSSQL\Data\ and make sure that the SQL service account has access. Note that it is possible to have a dir that administrator has no...

Bob Hovious (4/2/2009)

---

I tried, politely, to get him to give us more complete information to work with, and suggested that he get a good introductory SQL book and do his...

OS service packs and application service packs are completely unrelated and don't affect one another

Are you sure you read the link?

Part way down there's a link to a second article 'Considerations for restoring the master database'. In there there's a piece on starting...

Did you...