another option would be Merge Replication, now that i'm thinking about it;

changes would get shipped out on a regular basis, and once set up, you do not have to fiddle...

i think something like this would be better: it's set based, so it's fast, and if the data doesn't start with the offending char, it's not adversly affected:

--remove preceeding semi...

John Waclawski (6/10/2010)

---

I've been tasked to create a INSERT/UPDATE trigger for SQL Server 2000 to fire off the same INSERT/UPDATE statement to a corresponding table on a SQL Server...

'Imports System.IO

Private Sub btnSQLSplitter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSQLSplitter.Click

Dim myConnectionString As String = "data source={0};user id={1};password={2};initial catalog={3};Trusted_Connection=False;Application Name=SSCExample.YouApplicationName.exe;"

myConnectionString...

n00b (6/10/2010)

---

We're developing a product and I've created a .sql script that creates the database, tables, stored procedures, all the Service Broker configurations etc etc. The script itself works perfectly...

indupriya9 (6/9/2010)

---

I have a scenario where a user has access via a CRM application that is sql server based. This same user needs Management Studio access where I want...

well it depends.

if load = put the binary of the zip file into an IMAGE/varbinary(max) column, then that's possible.

if load dmeans open the zip/get the(one or more files!) from the...

Krasavita (6/9/2010)

---

I just re created table and I am ok,bit can't add data, what I need to do in order to insert data,should I disable a key and then re...

well, tempdb is a copy of the model db every time the server is started, so changing the model db would change the temp db after a start and stop.

ALTER...

here you go Matt: this is using a function which strips the string down and removes unwanted chars;

take a look at the logic, and see if you understand how it...

In that case, look...

if you use an enhanced text editor like EditPlus,NotePad++,UltraEdit or one of many others, you can do it in a couple of seconds flat:

copy and pasting from grid view of...

so much of what you want depends on specifics...the types of logins,which procs, whether they can read form an tables or not, etc, but this might give you some ideas.

the...

Wayne it's been a while, but i had a similar issue;for me, it was my laptop, which traveled between different networks a lot. i thought it was related to...

Karl in your case, since Tablediff takes username/password parameters for the servers it will compare, you could just include those and not have to fiddle with the startup accounts, but...