you are missing one closing parenthesis just before that END that raises the error.:

SET @Per = ABS((1.0 * (1-@RN)/(@rows -1)*100)) --<--missing last closing parenthesis...you

also, in the...

no, but a procedure can.

a function is not allowed to do DML operations...UPDATE/DELETE...only select, or calculations based on the select.

a procedure is allowed to update data, and of course an...

here's a skeleton to help you visualize.

I'm assuming:

1. a tracking table in the MASTER database...not the Vendors database.

2. a snippet to initialize the data...you have...

i would go with GSquared suggestion of creating a log table, insert how many rows are in the table right now,a nd then have a job compare the current rowcount...

i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

if you pass a specific login name, it gets scripted if it...

???

EXEC sp_help_revlogin 'sa'

/* sp_help_revlogin script

** Generated Oct 11 2010 12:10PM on DBSQL2K5 */

-- Login: sa

CREATE LOGIN [sa] WITH PASSWORD = 0x01004086CEB61FB1FE6C34DEC914CC131938263D12A9FA0B2EF7 HASHED, SID = 0x01, CHECK_POLICY = ON, CHECK_EXPIRATION...

ahh good job Cory! that's a good to know feature.

i noticed any changes there affect newly created tabs only...but that's not an issue.

very nice.

yeah i don't think the display aspects of the tabs are exposed;

I see what you are saying, there's filename, server info, login info and spid all in the tab;

it...

sp_help_revlogin is a script provided by microsoft which scripts out logins and their passwords as...

leaders_j that code snippet you have is really old; i bet it's from 5 years ago.

It's from a project i play with now and then that scripts any table via...

it's much easier to adapt a wheel than it is to re-invent one.

here is a function that takes a decimal and returns it as words in english.

you could easily adapt...

because windows groups can be granted access, and that includes people who potentially never logged into your instance yet, i think you have to query active directory for the...

I'm pasting a tried and true snippet of code that uses sp_OaCreate.

All it is doing is witing to files in the root of the harddrive: c:\header.txt + c:\body.txt c:\results.txt'

etc.

this can...

I am very sure it is not; an indexed view requires, among other things, that all the tables be schemabound...but that doesn't prevent you from creating a view that is...

leo it looks like you have two custom functions;

one is an aggregate function named LAG, and the other is a function which returns a date based on some business rules:...