SELECT * FROM msdb.dbo.sysdtspackages

Field is owner..

CEWII

You could probably build a database DDL trigger that captures the version and stores it.. Just a thought..

CEWII

The more exotic the more documentation you should have..

CEWII

Exactly.. You use the lookup to find out if the record exists, there is a little bit...

I'd like to make an additional comment on documentation, inline documentation is a must. When you look at code there should be comments there explaining sections. If you...

I don't think so, however, you may need a Client Access License (CAL) depending on the server version and how the server is licensed.

CEWII

Probably, but if you have a 16 character field and you only want the last you and you know there will be data there, it would seem RIGHT is the...

If I understand your problem.. You inserted a bunch of values and when you select them they are not in order..

I can see 2 possibles.

1. Order...

If I understand your request, add ", no_output" after @cmd..

CEWII

Fair enough.

CEWII

I have been doing some research for you on this and have some things for you to think about..

1. Are you sure that IIS virtual directory ReportServer security tab has...

I guess we'll have to agree to disagree, my experience has shown the opposite. So the moral of the story is test both, use what works for YOU..

CEWII

I can guide you..

Create a domain user (if the server is a member of a domain, if not a local user), this user doesn't need any special permissions yet.

Perform the...

I just noticed my points are off by about 25 as well.. 907 vs 932.. Hm, I wonder if it is tied to the freakyness I was having posting...

You could use a DDL trigger.. This would be pretty much the heart of it:

DECLARE @EventData xml

SET @EventData = EVENTDATA()

--SELECT @EventData.value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),

-- ...