Look at FOR ATTACH in here. It says that you can attach earlier versions: http://msdn.microsoft.com/en-us/library/ms176061.aspx

Note that the service account running on the new server needs rights to get to the SQL 2000 server. Along with that, use Anthony's advice.

If you print @Command, can you run it from a command window?

Have you checked the proxy that runs xp_cmdshell for issues?

The error is what is says. The CTE needs a semi colon before it runs.

If you have a CTE using the WITH statement, you can't have this.

select col1 from mytable

with...

Satyen has what I'd suggest. The connection dialog in SSMS may not default to master.

Quick hint, write a select to find the rows you want to update first. Make sure that it returns the data you need.

To follow on with Joie's note, here's an article: http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/

dstanger-666122 (10/25/2012)

---

Hi Steve,

Regarding "I wrote that calculated data growth for all databases on an instance and then used that to calculate how many days would elapse before I ran out...

I swear I moved Mendenhall off and another RB on, but apparently not. The SF defense rocks and Fitzgerald (once again) does nothing.

I give up. Can't seem to get anything...

A driver installed on whatever machine is running SSIS. Usually this is the same SQL Server instance, but it does not have to be.

I intended UPDATE statement. I know that an update can be a delete/insert at times under the covers, but since I have not found documentation that links this issue to...

It depends. If the FK column is used in the queries, I'd combine them. If it's not, then it won't help you.

You do want an index with the FK column...

powershell.

http://ask.sqlservercentral.com/questions/1568/execute-a-query-against-multiple-servers.html

If I understand, you want to allow a user to change permissions on a view they have access to, correct? Not change the view, but the permissions?

I think you need...

When I worked at JD Edwards, OneWorld stuck an MSDE (Express) instance on client machines to cache some data.