Don't think so.

And even if there's an option of doing...

Did you check if the database is in Full recovery mode?

No, that's not possible. Each instance must have it's own Cluster group.

The most simple option would be using LIKE

SELECT myvarcharCol from mytable

WHERE myvarcharCol LIKE '%project%'

Another option would be using the PATINDEX function

SELECT myvarcharCol from mytable

WHERE PATINDEX('project',myvarcharCol) > 0

The bak file only contains the data pages which are used. But when you restore it, the mdf and the ldf file are recreated with the size they had at...

You can't use like but you can use the InSTR function instead. Just like Patindex in SQL it returns an integer if a string is found in another string.

Something like...

Carolyn is right. In otrder to change the server collation you need to re-run setup from the command line with the following options

start setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=

But...

Restoring the database on the mirror server with the norecovery option is right. Your error message points to a network connectivity issue. Of course lot's of possible reasons for this,...

What do you mean by "configure security"?

Once you restored the backup to the mirror server with norecovery, you can start the mirror session from your principal.

The only security...

If you just want a list of column names you can use FMTONLY

SET FMTONLY ON;

GO

SELECT *

FROM MyTable

go

SET FMTONLY OFF;

You can create a trigger on the syscategories table in msdb, which logs all the changes.

Personally I'm not a friend of the various Kill process scripts you can find on the web.

I prefer to set the database in single user mode before starting the...

About the maintenance plans not running.

First of all you should install SP2 because maintenance plans on the RTM version had quite a lot of bugs.

Second maintenace plans make use of...

Check if you mdf file is read-only. If the primary data file being attached is read-only, the Database Engine assumes that the database is read-only.

I'm also curious which OS...

Sorry can't test your version now, but my original formular works on grouped data as well.

All you have to do is in the layout window in VS apply the...