very handy Ged;

I added another selection below that you can use if you have stored procs or functions that have been renamed the same way; Thank you for writing something...

not fixing an issue like this could cost you your job. The great thing about posting here at SSC is you can build off of other's experience, and avoid the...

hadn't seen it before either; tested it and it works on my sqk2k machine:

SELECT name

FROM sysobjects

WHERE { fn LENGTH(name) } > 30

[edited] sure enough, it's in the BOL:

Functions for...

there's a famous full featured script that does exactly that;

http://vyaskn.tripod.com/code.htm#inserts

you'd do something like

EXEC sp_generate_inserts  'tbcounty' and get results like this:

or a subset:

EXEC sp_generate_inserts  'tbcounty' ,@from="from...

Sergei is right, but there is some extended stored procedures you can put on your sql 2000 server in order to use regular expressions in SQL 2000:

read this for all...

do you mean when you view it in Query analyzer?

QA is limited to displaying 8000 chars or 4000 nchars for a column value; so if you do "SELECT someNTextValue...

I do the same as Jeff, with a little bit more data: i save the filename, file size, and the CRC of the file in a database;

I do this because...

Rudy and David are right on target;

You KNOW it is only a matter of time before one of your developers runs an UPDATE or DELETE statement against production as well;...

id like to hear why they cannot use an identity column. is it because the application is using the borland BDE as the provider to the database?

the correct solution is...

multiple file groups are always recommended; I'm pasting a script to help you out with a tiny slice of it: after you've created multiple file groups, the script below can...

hard to track down; good question;

if a table is assigned to a filegroup, it stays within that file group.

if the filegroup is comprised of more than one physical file, when...

the identity function is smart....if there is a max value in your db with the value 1058, if you try to reseed with a value LESS than the current max...

normall, you just do ALTER TABLE UsersImport ADD userIdInt int IDENTITY (99,1) to start at #99.

with a variable, it's a two step process:

declare @C1 int

set @c1=99

ALTER TABLE UsersImport ADD userIdInt...

note that the log readers are great, but only work if your recovery model is set to FULL; if it is simple, then there's no log to read, and thus...

updated!

Thanks again for all the feedback.

Thanks to David Russell for pointing me towards the fix for some subqueries returing more than one row;that bug is fixed.

other things i did:

added functions...