Review this thread: http://www.sqlservercentral.com/Forums/Topic561810-5-1.aspx

From SSMS 2008 and above:

1) Create a group in Registered Servers

2) Register the servers into this group that you want to work with

3) Right-click the group, select New Query

4) Run...

Create a new Integration Services project in BIDS. Right-click on the SSIS Packages folder and Add Existing Package.

In the dialog box, select the correct package location, the server and...

Neither the...

Compatibility mode affects what commands are available in that database. It is used generally for backward compatibility to allow legacy code written using deprecated code to run on a...

How about this:

SELECT *

FROM #s

WHERE name collate Latin1_General_BIN = upper([name])

Sorry - don't have another URL and not sure why your virus scanner is seeing something that isn't there.

Here is an example from that site, which shows how to create...

Take a look at this article: http://support.microsoft.com/kb/934396

It sounds like you are building up a SQL string in your code using concatenation, and then submitting that to SQL Server to be executed.

Please be aware that technique is...

shaunspad (1/27/2010)

---

Yeah looks like I read that page wrong. Sorry for the confusion.

However I'm not detaching the DB's when I move them, I'm simply taking them offline. I'm...

For future reference, it is much easier to install the system databases into their final location instead of using the default values and then moving them.

During the install, select the...

CirquedeSQLeil (1/26/2010)

---

Backing up the database will only backup the used portion of the data file and then restore that portion. The extra time to process is due to creating...

A couple of previous suggestions recommend changing the recovery model to SIMPLE and back to FULL. That should only be used as a last resort because it will break...

Here is the article I was referring to: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

The sizing at 8GB probably is not relevant for you - but, the information on how the VLF's are created will probably...

CirquedeSQLeil (1/26/2010)

---

Paul White (1/26/2010)

---

Oh so The Dixie Flatline *is* Bob! I missed the transition somewhere...d'oh!

Thanks for the high...