Look up datediff in Books Online. It takes two parameters (dates) and a scale (day, week, etc. ) and returns the number of the scale in between the dates.

select (d,...

I'm not sure how this works or if I understand what you're asking. please be a little more clear and give a bit more information in the question.

Are you asking...

Santa's all out of prizes for now.

I'm going to try Ultimate rather than hassle with XP too much for now. Slightly worried about drivers and I don't want to waste...

In 2005, Configuration Manager. I think it's also in the error log and possibly the Windows Event logs.

You can do a netstat -a and look for the listener. I think...

What's the error? I think you want "use databasex go alter proc xxx ..."

Dedicated is a better word than sick 😛

Actually it's such a habit for me and since the desktop and office are mere steps from the kitchen, garage, and family room,...

The above post was an advertisement, so it has been removed.

We do not take advertisements in our forums.

Please do not cross post.

Check here: http://www.sqlservercentral.com/Forums/Topic436236-17-1.aspx

You can't create a dynamic stored procedure like that. You would need to specify each variable:

create proc myproc

@a1 int = null

@a2 int =...

Merry Christmas!

And I don't think I've been doing this long enough!

😉

You can alter a stored procedure from a client by submitting an ALTER PROCEDURE statement. You can do this within a stored proc by using dynamic sql.

The maintenance plans runs as a job, so you need a job reporting system.

You can query the msdb database on each server in multiple ways, script a connection to each...

If that doesn't work, you can try these guys: http://pwcrack.com/sql.shtml

You can save them out as VB packages and then perhaps write something to dig through the code, look for various tasks/connections, and provide some rough idea of complexity.

Most packages...

I'd pick up any of Itzak Ben-Gan's books on T-SQL. That will help.