A SQL Farm would be some type of cluster where you install and manage multiple instances. You can do this with standard Microsoft clustering, but - this can be...

How is the data actually stored in that column and what is the data type of the column?

I don't know where the * would be used in SSRS, unless you are using built-in functions.

As for the queries, the wildcard that you have won't match if the name...

The asterisk '*' is not a wildcard character in SQL Server. The % is the wildcard that means match any characters.

Lookup LIKE in Books Online for the different wildcard...

In SQL Server 2005 and above, maintenance plans are now stored as SSIS packages. The connection information is stored within the package.

So, your only option is to delete the...

WayneS (8/27/2010)

---

In T-SQL, this will work:

select [StartOfYear] = DATEADD (year, datediff(year, 0, getdate()), 0),

[EndOfYear] = dateadd(day, -1, DATEADD(year, datediff(year, 0, getdate()+1), 0))

Reporting Services...

In addition to what Gail stated, after you offline the database - you need to alter the database and modify the filename, then copy the physical files to the new...

You need to put parentheses around your select statement:

DECLARE @FValue varchar(50)

SET @FValue = SELECT count(SomeField) FROM ADifferentDatabase.dbo.SomeTable

Should be:

DECLARE @FValue varchar(50);

SET @FValue = (SELECT count(SomeField) FROM ADifferentDatabase.dbo.SomeTable);

Or, you can change this...

Are you talking about the default database defined for a login? If so, then you are going to get different answers.

Setting the default database to the user database will...

Gail's suggestion works - and might even be the best option. However, there is no reason why you couldn't create your objects in another database to work with the...

You can use sp_change_users_login to fix orphaned users. There are different parameters - so you'll need to look it up in BOL for the exact parameters you'll need.

As the error states, create/alter procedure must be the first statement in the batch. In your dynamic query, you need to separate the USE from the CREATE/ALTER with a...

DBAgal (8/23/2010)

---

Hi all -

I just wanted to see what people's opinions were on this subject. Here's the info:

My current goal is to move all of my databases to...

Jeff Moden (8/21/2010)

---

GilaMonster (8/20/2010)

---

Now...

It is going to depend upon what the organization expects from the DBA's. If all you are doing is production support, then a single DBA could handle all of...