good question actually.

at some point, the connection to the database that is going to be upgraded has to be input...

Like me, I'm sure you've noticed that you've never seen an...

if the stored proc is doing ALTER TABLE and then anything else, i think you have to switch to dynamic sql for the ALTER commands.....that fixes the GO statement, since...

ahh, that's our point...if you don't have a handle on LOGON triggers, read up on them,...

here's a proc i have laying around for that situation with dyn named FK's: drops all the FK's on a specific column in a table

usage is simply EXEC DROP_FK_FROM_SPECIFIC_COLUMN TableName,ColumnName

if...

could it be possible that ANOTHER foreign key, a duplicate the specific FK you are looking for, but with a different, dyamically create name exists?

it's possible, unfortunately, to have duplicate...

yes you can, but you have to use a logon trigger to do it.

I'm sure there's more to it than the # of connections that you need to figure out...

yes you can change compatibility mode without a problem;

compatibility mode only tells SQL to filter the commands coming in against a set of version-specific-syntax; it does not change how the...

if the windows user has been explicitly assigned a login withthe server roles sysusers,

or belongs to a windows gorup that has been assigned sysadmin rights (like BuiltIn\Administrators),

then that user...

yes it is; as a matter of fact, here's something at codeproject that has a screenshot-by-screenshot, step by step example:

http://www.codeproject.com/KB/database/MergeReplication.aspx

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...