Hi,

The folders below:

Samples\Reporting Services\Report Samples\Server Management Sample Reports\Execution Log Sample Reports

no longer exists from the CodePlex link. Does anyone know the updated path or where to get a copy from?...

Thanks again,

If a reboot is indeed required after the update, then I will be for sure running the updated instance on one of the node that is pending a...

Thank you Perry,

Good to know about the shared features. I am trying to avoid a reboot on passive nodes as I have 6 instances in the cluster. I am referring...

Great advice. Thanks Tom.

I am a SQL server DBA in the San Fran Bay Area. I love what I do as a data professional and think I am well compensated. I believe I...

Thank you all for your response. I am very grateful for the amount and level of details of all responses. Especially your time. There is no where else like SSC....

Thanks for the replies. I have only two file groups, primary and secondary and about 20 database files on SAN. The 4 local backup storage I have are MSA drives....

Thanks. But we don't have Office installed on server, and installing one for this one off case will not make sense license wise. However, save it as normal Excel does...

Tried XML source. Error with both inline schema and XSD. It was unable to parse the file. :(. Want to add one note, I was able to open the .xls...

The package was created by a sysadmin account in 2k. I can see All versions and open this with no issue. With management studio, I can see the pop up...

Thanks SQLBuddy, the issue is more serious than just not being able to see previous versions. I was prompted to select a version, but none available to select from, not...

meant to add the following point to the original post. all sources I came across from initial research links the communication link failure error to network issue, well, it could...

You don't have to do a thing. I am speaking from experience...SQL Server will pick up the new server name for both SQL Service and Analysis Services. This is a...

I had the same problem this morning, but with slightly different message...

Msg 22050, Level 16, State 1, Line 0

Error formatting query, probably invalid parameters

Msg 14661, Level 16, State 1, Procedure...

I was asked the following question during an interview for a SQL DBA position.

"what is the difference between hot backup and cold backup"

I answered the question to my best knowledge...