403 is web page permissions....

maybe you can FTP or SFTP to your server? since it's a web page error, i assume your other server is remote over the internet and...

back up the database, zip, transfer to the new server, unzip and restore is sure to be the fastest way as well as the most dependable;

transfering over the wire, for...

my absolute favorite posts to read are the ones where they say "urgent" in the title.

they are invariably from a poster who just joined, has less than 5 posts, and...

As Jeff said, chances are whatever you were going to do, you could do it in tSQL;

outside of that, you can use sp_OACreate to run vbscripts, or an executable, or...

SQL server doesn't bother with changing data tytpes when it sees integer divided by integer...it returns an integer value.

change so that your 2 is 2.0:

RETURN 2.0/(@Period + 1.0))

Follow with what Jeff And Lynn said; repalce with an int where isnumeric is true:

UPDATE YOURTABLE SET Login = Convert(varchar,CONVERT(INT,Login)) Where IsNumeric(Login) =1

the rows like 'jc4444' will not be...

by using a Tally or Numbers table, you could insertall the items, with the proper qty's in in a single statement:

CREATE TABLE #TEMP (QTY INT, ORDERITEM VARCHAR(30),MORESTUFF VARCHAR(30) )

INSERT INTO...

there was a different thread on zipcodes here where i posted a text file to a bunch of zip code/city/state stuff...are you just trying to get a list of all...

since current_timestamp is a variable, it really doesn't matter which table you get it from;

by same question, you mean from a linked sql server?

i did select top 1 current_timestamp from...

oracle has SYSDATE ahs an equivalent of our GetDate();

oracle would be SELECT SYSDATE FROM DUAL;

(oracle syntax requires a FROM clause...DUAL is a dummy table that can be used to supply...

the thing is, the XML gets chopped right in the middle....you can't loop thru it, because it's not like each 8000 chars are well-formatted XML. it'd truncate something;

without upgrading,...

since a third party software is invloved, and you can't change the datatype, I have just the tool for you.

I've used this to Find-And-Replace within text fields lots of times...for...

yep you are ring....your getting an issue because ov the varchar(8000)

150 lines X ~80 chars per line or so, and you pass the limit for the definition.

this proc, on SQL2000,...

wait, i think i get it....still use a loop or FOR XML to construct the complete set of statements, and run the massive varchar(max) as a batch, instead of line...

ok...i'll bite...how do you find each column that hass null/empty string as a report without a cursor?

at least in this case, i only saw dynamic sql and a cursor....i can't...