So more than likely TCP/IP is failing and SQL Server is using Named Pipes rather than TCP/IP. I'm pretty certain that Named Pipes is the default setting. Next time you...

Bill,

I think you need to re-read the third query.

Kevin,

I don't see why you would have a problem with your third query. I also didn't have time to create a...

Actually I think your multiple IF statements are easier to read. But...

SELECT @test1 = case convert(varchar,@a)  WHEN '0' then 'XYZ' END

, @test2 = CASE convert(varchar,@a) WHEN '1' THEN 'abc' END

,...

Sorry I didn't respond sooner. But I was having trouble getting a cursor in the reply box when I was at work

If your...

I usually do all my data modeling in Erwin. It then creates a script that I modify to create the tables and triggers. Once I have run the script I...

Yogi,

Doing the Select <fieldlist> INTO <newtblname> FROM <originaltable> will create the table for you with the same structure. It won't however create any constraints or indexes. Often times I will...

As you surmised you will want to use SELECT INTO...

SELECT

<fieldlist>

INTO <newtablename>

FROM <oldtablename>

You're correct that a dristributed transaction could be used. So might SET XACT_ABORT ON. The biggest problem is that these transactions are based on a dynamically entered value from the...

My replication scenario is probably different than 99.9% of people. We use a replicated environment to act as a source control of the data in the database. We have people...

As Frank stated I don't think there is a LAST or FIRST but you can certainly use the ORDER BY with TOP 1

select nbr, type, last(location) as Lastoflocation from loadplans...

Dana,

In the post that Frank points to the line that states "this is a powerful feature that you should use with care" is the one you must take to heart....

Well it will be far less work to re-initialize. You just need to make sure to sync up all your subscribers before modifying your schema and re-initializing.

Managed identities are when you have a column in the table with the identity propberty turned on but the "Not for Replication" flag set. Then when you replicate the database...

I would submit that the Format function belongs to the front end app and not in SQL. The front end application is the only app that truely knows how the...

I would have to say it all depends. If you are simply adding new tables you might be better off just adding another publication. If you can get all the...