How Can i Find the last Modified date of a Proc
Thanks DaveL

hi, i have some huge logs, how do u empty them , from time to time
DaveL

First post here and let me say up front that I am completely and utterly
ignorant about SQL servers.  I don't know what one is and I didn't even know
that I had one until I was browsing around in my Microsoft Office Accounting
08 Application.  So if you can be helpful then also ...

Hi All--
I have a column which contains an ID value. I also have a URL column
(within same table) which contains a NULL value,  that I am trying to
update with a URL value + the value in the ID column. Here is the

I just hard to rebuild my entire pc and that included reinstall SQL 2000 SP4
Developers Edition.
I have a database that is configured recovery model full
this gives me transaction log backup also.

If I have a calculated field that returns a value from a udf, does that
field get calculated even when it's not being used in a Select statement?  I
knw that if a calculated field's formula is based on fields in the same
record that the calculation is only performed when one of ...

I have an 3rd-party application that uses a SQL back-end, but uses
Access 2000 (linked tables all using the same DSN) as an
intermediary.  We recently upgraded from SQL 7 to SQL 2005, which went
fine.  Now, however, we want to setup SQL Mirroring to provide

Hey all, I've noticed an obscure little quirk: it appears that if you
use a login with trailing spaces on the name, SYSTEM_USER
automatically trims those trailing spaces in SQL Server 2000, but not
SQL Server 2005.

We use BES (blackberry professional software) on a MS SBS 2003 Premium
and we back-up the whole system with Symantec backup Exec 12.
BES uses an SQLdb for management.
Since the day we installed BES we have this backup error in Backup

I'm trying to construct a SP like this:
<code>
CREATE PROCEDURE UpdateInvoice @companyname varchar, @docno int AS
 BEGIN

I need to buy a sql server standard edition for an intranet application.
From MS site I see that you can license sql standard edition "per server"
(=processor) at  6,000 USD or "per user" at 1,850 USD per 5 CALs.
Now I have received a quotation for a standard edition "single user" ...

Hi Hows it going , I need a Fast way to check for duplicate rows in a single
table
the identity keys and Primary Keys dont play in this scenario
i have like 10 columns

My SQL query is like:
SELECT .....
FROM tblCLAIM C INNER join tblXXX .... INNER join tblYYY ....(5 more
joins)

I have a name of a person that particiaopte in one or  many meeting at
different date of the year
Name        Title        Meeting date
Eric Rose    Reporter    2 feb 2008

I'm running SQL Server 2005 Express Edition.
One database
One table called Sites
Fields as follows: