you will need to build a custom DDL trigger which consumes the XML for the ALTER PROCEDURE and ALTER TRIGGER events and splits out the ALTER command, user and date

this...

do you have digital media or physical media, if physical you should have received both x86 and x64 disks if virtual, then you should have access to the MS download...

do a foriegn key to the same table and pass in the right manager employee id for the employee, standard parent child relationship

the account which SQL is running as

only other thing I can think of now is permissions to the procedures

what level of access is the user which is running the mail task?

does the sql account have permissions to the shared folder?

also try to stay away from mapping drives if you can, use UNC paths instead, if you cant get around mapped...

is it the same error or a different one?

also is that email address right in the snippet or was it modified?

is there anything in the database mail log?

av blocking mass...

this will do the trick

sp_configure 'show advanced options',1

go

reconfigure

go

sp_configure 'Ole Automation Procedures',1

go

reconfigure

go

from what I remember, if you dont have more than 5% data change in the table then stats dont get updated unless you manually issue update statistics.

this is great for...

anthony.green (3/30/2012)

---

you would have to build in some logic to the parameters like

if @minage < @maxage do nothing

if @minage > @maxage set @minage = @maxage, @maxage = @minage --needs to...

to add the second file you will need to restore the secondary db, doing this will break logshipping, to get logshipping working again you need to restore from full backup,...

http://msdn.microsoft.com/en-us/library/dd938891%28v=sql.100%29.aspx

I would read this document than ask any questions which you dont understand.

Top level overview would be you have a set of Facets, which are used in Conditions, which are...

can you share the links which you have read on this so that we can check them out, as this cannot be done, so I am thinking it might be...

to add on to what Henrico and Grant have already said, it might be worth going through each folder in object explorer finding every objects and generating scripts for them...

this should do the trick

with cte as

(

select

ROW_NUMBER() over(PARTITION BY typ ORDER BY val desc) AS RowNum,

Id,

TYP,

val

from

test_groupby

)

select ID, Typ, Val from cte where rownum = 1