Your format is wrong, the command could be:

master..xp_cmdshell '\\Server\Share Folder\Something.bat' -

('\\...' is a server path)

or

master..xp_cmdshell 'C:\Local Folder\Something.bat'

ALTER INDEX with REORGANIZE is a better option, but INDEXDEFRAG is still available (http://msdn2.microsoft.com/en-us/library/ms177571.aspx). Bad question!!!

Worked it out ... I got rid of the NON EMPTY clauses in the MDX query, and it works as required.

Steve - thanks for...

Before you read this, I have to add the disclaimer that I just copied this from BIDS - I dont actually understand it (I'm working on learning MDX, but...

SP2a is called SP2 - you can't get the previous version any more!

Are you trying to open the Maintenance Plans with a non-SP2 version of SSMS? If so, try patching...

Can you split the database into multiple filegroups? If so, you can use a filegroup backup and restore stategy, instead of a full database strategy. I haven't used it personally,...

Mr Lockwood,

I believe you misinterpreted my comments (probably deliberately). My inclusion of "(American)" has nothing to do with anti (or pro) American bias, it was simply an acknowledgement that there...

One thing that no-one has mentioned - the number of times Mr Boule posted his message has to qualify as spamming the forums.

Did anyone else read Mr Lockwood's...

I agree with Andre - this was a very badly worded question.

If you're looking at your future career, I would strongly suggest MCDBA to start with, then progress onto MCITP - there are going to be a lot of SQL 2000...

How you do it depends on how you want your data spread out ...

If you want to split up your data by table (a table resides in a specific filegroup),...

Visual Studio is now the programming interface for SQL Server, and SSMS is the administrative interface (of course, you can run queries in SSMS, and use that as the development...

Isn't there four options for Receiving an MSMQ message - "Data File Message", "Variable Message", "String Message" and "String Message to Variable"? I think the option you'd want would be...

Mohammed,

thanks for the suggestion. We actually tracked down the error - the application that sits on top of the database couldn't handle a ' in an email address. The application...

I ran a trace grabbing everything from the server, making sure I included a period where the CPU utilization was spiking, and saved the data into a table on my...