thanks for the feedback Bill;

I had initially tried to use the INFORMATION_SCHEMA views to build a script like this...the problem is, those views do not contain all the information. which...

it's in books oline:

BACKUP MASTER KEY

RESTORE MASTER KEY

http://technet.microsoft.com/en-us/library/ms174387.aspx

excellent job posting the CREATE and INSERT statemetns.

Thank you!

getting the output you want is easy; it's exactly what the new row_number() function is for.

updating the existing table is hard,...

if you could provide the actual table definitions, you could get a more refined answer.

basically what you want to do is LEFT join all the tables, so you get either...

I'm assuming you want to see the text of your procs....

any of of these will get you started:

select * from INFORMATION_SCHEMA.ROUTINES

select * from sys.all_sql_modules

select * from sys.procedures --just procs

only way i could think of was to use parsename and do a double convert from int back to varchar:

declare @ipAddress varchar(20)

SET @ipAddress='010.000.123.094'

SELECT

CONVERT(varchar(3),convert(int,parsename(@ipAddress,4))) + '.' +

CONVERT(varchar(3),convert(int,parsename(@ipAddress,3))) + '.' +...

you might want to attach your proc, instead of copying and pasting it.

just from what you pasted, i see one way to improve it:

you mentioned you are using some functions,a...

I've done almost the same thing that Grant is talking about;

for a .net web page suite, we slapped together a couple of utilities that spidered all the web pages so...

not really...you could call the procedure prior to your users calling it to get it compiled, but it depends on what it is doing. does it just SELECT data or...

that is normal.

the first time a procedure gets run, an execution plan is created and saved. that takes longer.

after that plan is created, subsequent calls are much faster.

if the procedure...

ok i think i see the reason, but not the solution.

float, without the size defined , is defaulted to a float(53), which is an 8 byte double precision.

if i...

how about the free one from microsoft? one of my web hosts uses it, it's basically a web based SSMS/Enterprise manager:

Download details: Microsoft SQL Web Data Administrator

it looks like all you want to do is remove the extra zeros.

to do that, you need to decide on the precision of your @A5 variable.

here's your same code,...

something like this is pretty close; I don't know the sql to get the temp table, and I'm not sure of the table that the old function uses.

the sql...

your function is fine, it's the function call...

since it is returning a table, you need SELECT * FROM, not SELECT:

select * from dbo.testFunction(getdate(),getdate()+30);

--results:

2009-07-27 00:15:08.460

2009-07-28 00:15:08.460

2009-07-29 00:15:08.460

2009-07-30 00:15:08.460

2009-07-31 00:15:08.460

etc....