Where are you performing your scripting?

From QA or EM.

Your QA Connection Properties may be having an effect on this.

Ahh,

Sparking up the big debate.

Your in the gray area that causes everyone to share their opinion.

to me I always lean towards stored procedures because they are closer to the...

Don't cross post, People usually look across all the boards Finish it up here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=231206

Single user mode means just that, you guys are gonna have to share, and take turns.

Well a quick check to books online showed me that both QUOTED_IDENTIFIER and ANSI_NULLS are database options.

In EM Right click on your database, select properties, go to the options tab, and...

If you read it, it must be true. You need SQL Enterprise Edition to perform log shipping.

Since you are copying backups to a different server you should be safe, but...

Well if you try you get a message as such.

Server: Msg 8102, Level 16, State 1, Line 1

Cannot update identity column 'pk'.

So no you cannot easily do it.

What are you...

I do not know how to pull a sql servername/instancename using dos.

You can run the script using variables as such.

Google for some dos commands and you can probably get a little...

select AOofficeName as Office, count(ARid) as totReferrals ,UserName

from AdminResource, ProfRequest, Users, AdminOffice

where ARenteredDate BETWEEN '01/01/2005' and '10/18/2005'

and ARcurrentStatus >= 0

and ARprofrequestID = PRid

and PRschoolworker = Uname...

If you use an identity integer with the same seed and increment. and a insert happens to the same table on 2 different servers it is going to insert the...

What primary key strategy are you using with your merge replication?

With merge replication you have to use a more unique key than an integer, or bigint. Such as a guid.

Or...

Indeed,

Instead of INsert into table (DiffReason) values (NULL)

try using the Default keyword

INsert into table (DiffReason) values (Default),

Where is your group by clause?

This query does not appear to be complete.

Try adding the username to the group by

Osql is in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder, and this information should be in your "Path" environment variables after install.

Open cmd window and type osql have you tried?

just like...

Since your mentioned your log shipping, you have to understand that reindexing will inflate the size of your logs forcing you to ship more data over the wire when the...