Use an Instead Of trigger. The sample code below would be more efficient if there is some unique key field that you could use to join the records instead of...

Has this server been the witness previously? And has there been any server changes?

If you remove the witness, it retains the configuration settings. If you reconnect, it over-writes the previous...

"Use Output Window" is greyed out in my SSMS. What does that do?

Or the article I wrote, Practical Uses of PatIndex: http://www.sqlservercentral.com/columnists/rdavis/practicalusesofpatindex.asp

I demonstrate a much simpler approach to this:

Create Function dbo.fnDigitsOnly(

                         @value varchar(50))

                Returns varchar(50)

As

Begin

    While PatIndex('%[^0-9]%', @value) > 0

        Begin

           Set...

That's not the correct syntax for changing the file sizes of the database.

Alter Database [dbName] Modify File (

          Name = [LogicalDataFileName],

          Size = [NewSize][KB|MB|GB|TB])

Alter Database [dbName] Modify File (

          Name = [LogicalLogFileName],

          Size =...

It works for me most of the time. When it doesn't work, it is because a db is failing one or more tasks. This only happens occasionally and usually it...

You can use relative paths if you put a pushd command or a cd command at the top line switching the directory location. Like so:

pushd C:\scripts

start MyExe.exe

You can use NewID for this:

Select

Cast(Cast(NewID() as

Do the names have any non-alphanumeric charcters in them? I've read that removing these from the package names has helped some people.

I've lso read that you should download and install SQLServer2005_BC...

UpdateUsage won't help with his.

Making your growth rate small will speed up expansion, but it will cause it to occur more frequently which will hurt performance.

When you installed SP4, did you run the instcat.sql script that comes with the service pack? That has to be executed separately after the service pack installation. It upgrades the...

You can also fire up a VPN connection and use mapped drives instead of a trusted connection.

I'm not saying that this is any fster or better, but just another alternative:

Right(

'0' + Cast

You should definitely run the backup locally and then copy/ftp it to the other server. Your chances of getting a corrupted backup go up exponentially if you do it cross...

There are a couple of ways to do this;

1. Have every available whole number width and every available whole number height associated with a price. Either have every available width and height...