it looks to me like you are duplicating what Visual SourceSafe does. Can you force everyone to use SourceSafe in order to manage your documents and the changes that occur to...

would something like this work for you?

Create Table Employee(

EmpNO int, 

DayOfWork datetime,  

HoursWorked int, 

[Holiday Code] varchar (30)

)

insert into Employee( EmpNO,  DayOfWork,   HoursWorked,  [Holiday Code]) VALUES(1,      '07/04/2005',  0,            'GovernmentHoilday(GH)')

insert into...

there's a bit of design issue here ;

the web page that this querystring was posted to had all those values in the Request.Querystring collection in the name-value combinations you wanted, but...

if you have access to a SQL7 instance, you can use the Import/Export wizard to move the database to the SQL7 instance, then back it up, and the backup would...

I 'm pretty sure you use the SQL Native Client provider to connect only to SQL 2005 instances., but I thought the native client had a dependancy to the .NET...

there is a script in the contributions section to check if a file exists...you could adapt it from there to call your functionality:

Perform an action when a file exisits

Script...

The database has been marked as "Suspect", not "Subject"..Suspect means SQL Server thinks it is corrupt;

i think you'll have to restore it from a backup.

I always refer to it as the "tour of the desks" when an application is installed manually, vs pushing a package out via active directory or sysinternals pstools or another...

I tried the alternate method, but the excess violence just caused me to replace the keyboard

still trying to figure out; this sql...

the documents table exists, i guess i just didn't include in in the example for brevity;

that may give me the kick in the pants i needed; i didn't think about...

Thanks for the ideas Remi and Hans;

based on your input, i enhanced the uglysearch a bit more; now i check to make sure columns are at least as long as...

we all agree that a monster scan like this is bad, but bad or not, sometimes you need to do it.

Here's a slightly updated version, this simply uses if exists,...

I made an ugly server intensive cursor for a similar question a while back;noone came up with a better example so far.

see the thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181099

it whips through every varchar...

dinesh that delete script  using sp_msforewachtable does not take into consideration foreign key hierarcies....so it will by default try to delete the4 tables in the order they were created...most likely a...

Query Analizer...heh

...too much pr0n on the brain.