You can use master.sys.sp_procoption by passing the name of a stored procedure which you want to execute at startup. In that, another S.P. you can specify your command.

SQL Srever Magazine.

sqlmag.com

That's right. Since you don't name the parameter SQL Server assumes that it the first one. But the first parameter is @indexonly where you are trying to assign 'fullscan' parameter.

So...

Here is how you can do it:

1. Create temporary table:

create table #temp(mydata varchar(max))

2. Download you HTML file into that table:

bulk insert #temp

from 'c:\my_path\my_file.html'

3. Use a cursor to read each row...

It is not such simple task as to fit into one table that serves all.

1. You can't have PreviousValue, CurrentValue for all tables and fields because they may have all...

You can also use this:

select

name

from sys.columns

where object_id =object_id('my_table')

and name ='my_column'

They are small because Diagrammer tries to fit all of them to screen size. Increase zoom to 100 or 75% for better readability.

You can also copy it to Clipboard for...

But information_schema is in each database context, while I need something on a server level. Besides, information_schema does not have a objects view.

So you are using Visual Basic to build dynamic function! I've never done it before, but at least it will be a reason to start using CLR.

I also have another...

That procedure is great, but I need a function.

Particularly, for my performance testing I am selecting metrics from sys.dm_exec_query_stats by cross applying it to sys.dm_exec_sql_text, which returns database and object...

No, it returns object name only in the current database context.

That was my next question. In such a case I will need to find some other solution.

What I want to build is a function that would return object name by...

Sugesh: most of the columns are fixed width, however some of them are varchar.

Pam: this is what I am also thinking about, I thought I would find a better solution.

Jeff:...

Answering for your first question, the next step can be a company CTO. I know some CTO's who have grown from senior DBA.

You will have to degrade DBA's (which is server wide level) to DBO's (which is on databases level).

However you will need to have at least one DBA still..