yeah a powerful procedure like that....falling into the wrong hands...i usually keep that one locked up using the WITH ENCRYPTION statment...it's just too much for some people....

this is just another...

the built in tools work best in my opinion.

Start>>Run>>Profiler

connect to the database, and run a trace for a few hours.

stop teh trace, and save to a trace file.

open Enterprise manager,...

Remi is right; further you can create temporary stored procedures as well....so that everything is maintained in an individuals session; the combination of temp tables and temp procs would be...

default constraints are part of a column definition...so you could see them by running sp_help tablename on a table, and any/all constraints on the table would appear on the list....

if there's not much more than uppercasing and trimming the entered values, i think i'd use 10 separate statements; it depends on what kind of processing you are doing after...

gotcha; if the file is open, then Word has an exclusive file lock on the document.

The fix is to always use a COPY of the file every time...

so you might...

hard for me to grasp what we are trying to do....can you give examples of the parameters and also the expected output/results?

what does @Address contain?

why can't you just jump straight...

ahh was this web based? i didn't see that.

I can tell you the error 70 is coming from vb or asp, because there is no error 70 fro SQL server...

This has nothing to do with SQL Server...i suspect that since you made changes in your SQL, and NOW the error pops up, you think it is your changes that...

could it be related to the similar issue found here?:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110704

another similar source of data is here: nationalfile.zip

http://geonames.usgs.gov/domestic/download_data.htm

1.8 + million records in the text file, it's featurename/city/state/county along with latitude/longitude of different places/features in the US.

because it is a lot bigger file,...

here's one suggestion:

http://geonames.usgs.gov/fips55.html

that has some files that has every geographic place name in the US.(158K rows)

you can also find similar data for free by searching for "zipcode database (that...

the procedure you posted, procedure GE_Claim_Record_Counts, does not do any selects, therefor the data cannot be sorted.

do you mean when you do SELECT * FROM ClaimCounts, with NO ORDER BY...

because you are not really sorting the results, but placing the results in a specific order, you have to do something like this:

SELECT * FROM ClaimCounts

ORDER BY CASE

WHEN...

insert into TableA (Account,OutstandingLedger

select Account,OutstandingLedger=$0.0 from TableB

don't do an assign operation in the select;

simply SELECT Account,0.00 from TableB