Try something like this...

UPDATE M

SET Port_Desc = S.Port_Desc

FROM master M

    JOIN ACCESS A ON M.OrderID = A.OrderID

     ...

You can't drop an article if you have any subscriptions to the publisher on Merge Replication. See sp_dropmergearticle or sp_droparticle in Books Online.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

If that doesn't work make sure that the 2 servers have the same sort order. That is the only reason I can remember for ever having a problem restoring a...

Rather than trying a fixed length type of file why don't you try a delimited file? That way you should be able to just export the nulls and then handle...

A generic script to do this could really be detrimental, ie: how would you go about making sure you have created the indexes for the best performance you need? This...

Well I don't use a maintenance plan for anything so I would do the following.

STEP 1 (transact sql script)

BACKUP DATABASE <DBName> TO <device name>

....

STEP 2 (operating system command)

COPY <filename> <newfilename>

I...

I've found the best way for me to make sure that my subscribers have the correct SPs is to use a DTS Package to copy the stored procedures and functions....

If you use trusted connections you could use the other type of connection. (Sorry I'm at home and don't have the code handy). I would probably go with a trusted...

I would just drop the server and recreate it. I would think that would be the best route to go.

DECLARE @LinkedServerName   ...

Take a look at Books Online. It gives you a nice table to explain it's output.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

Yikes, I'm hoping what you really want is to know what "FILE" you want to restore inside your backup file. For that you would want to use something like

RESTORE HEADERONLY...

One note: I found an error in my sql. You need to offset the start position 1 character to the right so it should be like the following..

The best practice here is to make sure that all his scripts to create the objects use the dbo.objectname. That way you will always know they are created correctly.

I...

Well I'll step in a little late here...

I would go with the single phone table but I wouldn't bother with the tbl_from field.

As a side note: I would probably create...

I think I would use the STUFF function.

DECLARE @Mask varchar(10)

    , @TelNumber varchar(10)



SET @Mask = '0000000000'

SET @TelNumber = '1234567'



SELECT STUFF(@Mask, LEN(@Mask)...