I posted a script for retrieving default for parameters in stored procedure.

May be you can use it for your purpose;

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=333

Check syscomments - it has description of the proc. in the text column, you may parse the values to retrieve the defaults

I'm not sure if that what you are looking for, but check the system stored proc MS_sqlctrs_users, it will give some info including memory usage by processes.

I wish we had standards like that. We had some default standards that came with packaged application and we have to follow them, but quite a few times we wish...

How about

rtrim(left(last_name,len(last_name)-1))

or left(last_name,len(last_name)-2)

Do you have to work on site or it could be a commuter position?

You have to use an error check and rollback your trans if @@Error<>0.

Check the script http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=275 that shows how to do it.

I agree, it's probably a NULL issue. You can prevent yourself from it using the following syntax:

Set auto_id = auto_id,

reg_no =coalesce(@reg_no,reg_no)

make = coalesce(@make,make)

etc.

That way you will leave the...

I like this article and started implementing suggested approach in my SQL development.

What database you using?

From MSDN:

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log.

TRUNCATE TABLE removes...

quote:

---

Hi.

Can anyone tell me how you change the default language of a SQL 2000 server Installation. such that when run "SELECT...

quote:

---

I have a inherited a new database that uses a stored procedure to recompile all of the tables in the database and...

quote:

---

Cool! Where do I get that neat little tool? (Log explorer)

---

There are free...

Check an article xp_sendmail Using a Microsoft Exchange 2000 Mailbox Fails with Mail Error 0x80004005 or 0x80007005 (Q293422)

http://support.microsoft.com/default.aspx?scid=kb;EN;q293422