Run the whole lot in a stored procedure!

dk-fr, do your environment have , let say a german SQL server installation and a italian/french client for example?

If you say yyyy-mm-dd what is the 'SET DATEFORMAT' setting on...

Would you be as kind to post a reference to the article?

Have a look at ThinSlicer! $0.00

One reference at http://www.microsoft.com/nz/business/tswaar.mspx

Discussion at http://www.sqlmag.com/Forums/messageview.cfm?catid=10&threadid=6183

OOPS!

Then copy the results window into the top window and execute it.

Now run the script for JNK, if it succeed then run the next lot, maybe table by table.

Change these...

BACKUP YOUR DATABASE BEFORE ATTEMPT ANY OF THE FOLLOWING.

Create a dummy table, like JNK, and copy a live table's data into it.

The script included will generate code to change the...

Open QUery Analyzer.

Copy/paste the script and execute, it consist of two select statement, harmless. Make sure you have selected the relevant database.

The script should produce a list of the tables...

I think your 'application' needs to be able to determine when there is a new table via creation date or an exists if servers can be linked.

Plan b: Generate an...

Have you try to debug sp on the server.

Agree with a5xo3z1. Had a similar problem with older ASP app which was brought back from archives. Resolution was rather then to let the users 'type' a date, use a...

Have a look at BOL 2000:

scan for startup procs Option.

May help a bit!

Should be able to generate script to automate, keep mind constraints, indexes,etc.

Full backup before.

Select Object_Name(Id) as [Table],

...

Rheejay, if one look at the statement with the Exists in mind, I am trying to determine 'are there any previous entries for the same code'. If not then this...

Bit rought around the edges!

Create Table TestII(IDi int,AID INT, [Name] Char(2))

GO

Insert TestII values(1,2,'ba')

Insert TestII values(2,2,'cr')

Insert TestII values(3,2,'de')

Insert TestII values(4,1,'ba')

Insert TestII values(5,3,'ba')

GO

Create Function TestIII(@intAID Int) returns char(100) as

Begin

Declare @v-2 Varchar(100)

Set...

Not the best!

Declare @d SmallDateTime

Set @d='31 jan 2003'

Select DateAdd(ms,-3,DateAdd(m,1,'1 '+Right(Convert(Char(11),@d ,113),9)))