I'm sure I've successfully added files to a database before, and they have been propagated by log shipping.

Does the same drive letter/folder for the filegroup exist on the secondary server?

Despite the attitude, I'll add my 2p worth.

You can't install from within SMO, but from within Visual Studio, you can create a process to call the SQL Express bootstapper, and...

What command are you using to shrink the database?

I suspect you are using DBCC SHRINKDB, which will not shrink the database file smaller than the original allocation size, which I...

Look at SQL Profiler and the Login Event

You can use a case statement e.g.

...

ORDER BY

CASE @sortby

WHEN 'FirstName' THEN u.FirstName

WHEN 'LastName' THEN u.LastName

...

end

If you are going to provide the ability to sort on columns that have...

Select host_name() should give you the name of the workstation initiating the connection.

Note... if this is a web application, then the connection will be initiated from the web server, so...

The SQL being run by sp_executesql is executed in a different process to the rest of your script, so @docTable isn't available to sp_executesql.

You will need to include the creation...

Yes it will read uncommitted data

From BOL

NOLOCK Do not issue shared locks and do not honor...

They are both publisher and subscriber.

For this case:-

Cluster 1 is the publisher and cluster 2 is the subscriber

For this...

That is exactly what I would expect, as that is the character representation of the hex string i.e. Hex DE is "Þ", Hex FE is "þ" etc.

select convert(char(16),0x50515253545556575859606162636465)

would yield...

If you prefix the guid with 0x, you can convert it to a char, i.e.:-

select convert(char(16),0xDEFE4787AC2D4351BDA6FFCA07CC0D00)

As far as I'm aware, there is no issue with installing different version if SQL on a cluster, and you don't even have to do them in any particular sequence.

I...

Why didn't they do the trick, this should work

WHERE (@Show4 = 'y' AND ID = 4) or (@show4 'y'...

Right click Jobs, click All Tasks, Generate SQL Script.

That will script all the jobs on the server.

I think you actually need to use:-

Select * from [MYTABLE] where [MYCOLUMN]= [dbo].[the Function I created for Encryption]('THE VALUE')