No I created a copy of the database and gave it a different name.

Nevermind I forgot to hit refresh in SSMS. I got the copy.

OK Now I"m going brain dead. I had a copy of my database...named it LIMSTRAIN, but ended up deleting cause was gonna try the options in this list. ...

OH ok Gotcha...will try that now...let you know how things go... BTW thank YOU VERY much for writing the script to help me. I really appreciate that you have...

I don't want to delete ANY tables, I just want to create a copy of the database and remove the data. I need the tables, intact just like the...

The download will include all of the tools available in the toolkit. There are two tools that you would be interested in for this project:

SQL Compare

SQL Data Compare

The first one...

Jeffrey Williams-493691 (3/4/2010)

---

To create a new blank database with the full schema I recommend the following:

1) Download and install SQL Compare from Redgate (trial edition is fully functional) and purchasing...

I guess I was thinking of it being audit....security...which forum do you think this fits in?

I'm sorry I am self-taught on SQL here using StarLIMS which is its own version of SQL but does take most T-SQL commands. The StarLIMS is the front end...

Not sure what kind it is...here is the code for the section I'm trying to stop the loophole:

[/code]

:IF Len(aOLD[1,K])>0;

:IF Len(aNEW[1,K])<>Len(aOLD[1,K]);

cRS:="BOB";

:WHILE cRS='BOB' .or.Empty(cRS);

UserInput(350,20,400,240,"Reason",{"cTX,20,160,350,60,TEXT,Field "+aFLDS[K]+" was updated. Choose the reason", "cRS,50,60,200,80,CD,Reason,Entry Error,Sponsor...

Basically does someone know how to disengage the little red X in the upper right of a window and how to not allow someone to use the cancel button???

Thanks so much you got me on the correct path, what I needed to have was this:

"Select distinct folderno from FOLDERS where CLIENTPONO like '%"+nCLIENTPO+"%'"

How do I get the SQL native client driver on my workstations to change it to be the native client because right now the driver just exists on my Server...

OK gang thank you so much for your help.

The problem was our front end has a password saved in it. SQL 2005 is case sensitive, but when the permissions...

LIMSUSA is there if I log in under sa and not what we used have the ODBC user set up as. But even if I change the ODBC user...