All you need is a SQL license allowing you to install Management Studio on your local PC or laptop. You do not need an additional server license.

Optionally, you can...

Since this is a case against a variable, I would tend to say it will probably perform ok.

If you case is using a column in the table, the case would...

What you described can easily be done through a Derived Column task.

You did not give much information, but you are probably looking for the Derived Column transformation.

For security and sanity, I would put them all on the same domain. However, this is not absolutely necessary.

SQL Replication will work using SQL Authentication. You can configure...

First try to use sp_ChangeDBOwner to change the database owners to sa.

If you cannot get that to work, detach and re-attach your databases.

I'll add to that.

It does break Management Studio. The database engines seem ok.

Removal is a different story and I was unable to get the CTP version of 2008 removed...

You can use Enterprise Manager to configure the publication and the distributor (if it is on a SQL 2000 server), but you cannot use it to create the subscription if...

If you are actually running a query with NOLOCK or READ UNCOMMITED, the error is typically because you are trying to read a row from a table that has a...

Ok, I thought about it for a minute and decided to see if I could do this with a recursive CTE because I have never seen it done that way...

For a pure SSIS solution, you can create a date variable and use a For Loop container. Each time you loop, insert a record into your table and increment...

I am assuming you are using Analysis Services 2005.

"is it better" That is going to really depend on what you mean by better. You need to balance performance and...

So I think you saying that SQL Server Central should not be sending us an email every time someone posts to a thread we have subscribed to.

Instead, it should have...

I am not going to post the details of sp_getapplock - they are in books online. You specify a name for what you are locking and if another spid...

Here is what I have done...

I created an XML file for production, test, and development. On my laptop, I placed the XML file for the development environment in a...