Steve Jones - Editor (10/8/2007)

---

I'd use something like Lowell has to generate a script. Be sure it's hitting the tables that you really need. Last thing you want to do...

you could loop thru syscolumns and find all the varchars and such, and build a sql statement to run:

select 'UPDATE ' + object_name(id) + ' SET ' + name +...

depends on what you mean by empty...chances are , it already is null, but it depends on the data.

does empty mean an empty string?

SELECT * from sometable WHERE somecol=''

in...

you are correct, simply run the installation, but there is a caveat: Standard and Enterprise versions can only be installed on Server Version of operating systems...Win 2000 Server, Windows 2003.

If...

can you post the trigger you are using for SQL2005? Also, could it be that you changed the trigger to After insert or something on 2005, when it was...

char 13 is a Carriage Return (vbCr) also known as

char 10 is a Line Feed (vbLf) also known as \r (i think)

in most PC based files, you'll find vbCrLf...

much more likely to be a DNS issue i would think; since it appears to happen once in a while, and not 100% of the time, I'd venture the guess...

the trick is to group by portions of the account number.

this produces the results you were looking for:

CREATE TABLE #Accounts (AccountNumber varchar(30), ParentAccountNumber varchar(30) )

insert into #Accounts(AccountNumber ,ParentAccountNumber)

SELECT '100-000-000',NULL ...

you could convert to int, which would be the number of days since the beginning of time(according to sql server that's 1900-01-01 00:00:00.000)

SELECT getdate(),CONVERT(int, GETDATE())

2007-10-03 23:07:05.640 ...

you get a rows affected for every sql statement performed. that means select,update,insert or delete statements each return the rows affected.

sounds like you had either a cursor or loop that...

you cannot rename an instance, it has to be uninstalled and a new instance with the correct name needs to be created. that means backing up non-system databases, and then...

also, a DTS job is slower thant he time it takes to backup, copy and restore a database, as well as being prone to the changes you are seeing.

I'd recommend...

the thing about color is that you MUST enter the double quotes to get it to work.

input = #0000FF is BAD

input = "#0000FF" is GOOD

you are right....the actual permissions are stored inside the database, and not in any master table.

this is by design, so when you backup and resotre, the permissions for the objects...

it's handled automatically by the operating system;

you might have one nic that has an internal IP for your network, lets say 192.168.1.50

the other NIC might have an IP address on...