There were some issues at one point in time with group by an user defined functions but none ( that I know off ) with columns.

If your query is...

Minimizing the data in the distribution can speedup significantly your process. Try reducing the time that distribution commands are kept in the distribution db (default 73hrs)... start with 36... for...

As one of the earliest member of this site I can't say anything else but congratuations! I hope that what you created is maintained for life.

Good luck!!

Well I am not sure then what is "your" issue, because

exec (' USE dba_data

SELECT object_name(i.id)table_name, rows, rowmodctr,''Index Name'' = i.name, ''Statistics...

If you pay close attention at what sergy posted you'll realize that there is a "use" statement *in* the dynamic sql

exec (' use ; do your stuff') -- back...

exec msdb.dbo.sp_help_alert

The simplicity of this is what reinforces even more the idea of a rushed UI on SQL Server 2005. How hard was to provide that? ....

By the way...

Jose Luis,

You can do all that without using any "tricks" regarding system tables

have a look at:

sp_add_operator

sp_add_job

sp_add_jobstep

sp_addmessage

sp_add_alert

The easiest way I can think of is you create one job then you script...

Ok I have to take this off my chest.

SQL 2005 "Management Studio" is in my opinion one of the worst piece of software ever written. The effort on the...

If you plan to query that table I vote for 1

Sure!

declare @col varchar(2000), @valueToSearchFor varchar(200)

select @col ='7104 7106 7112 7107 7132 7108 7150 7105 7110 7109 7111 7104 7106 7112 7107 7132 7108 7150 7105 7110 7109 7111 2'

...

declare @col varchar(2000)

select @col ='7104 7106 7112 7107 7132 7108 7150 7105 7110 7109 7111 7104 7106 7112 7107 7132 7108 7150 7105 7110 7109 7111 2'

select (len(@col)-len(replace(@col,'7104','')))/len('7104')...

select replace(replace(@databasename,'].',''),'[','')

Sorry for the bad news but let me put it to you this way:

You *are* missing your favorite show tonight!

You can create differentials and it can reduce the amount of time it takes to restore quite a bit

Well, it is 1000 in transactional.