Viewing 15 posts - 3,571 through 3,585 (of 4,272 total)
SELECT * FROM msdb.dbo.sysdtspackages
Field is owner..
CEWII
September 16, 2009 at 8:09 pm
You could probably build a database DDL trigger that captures the version and stores it.. Just a thought..
CEWII
September 16, 2009 at 3:52 pm
The more exotic the more documentation you should have..
CEWII
September 16, 2009 at 3:48 pm
You could use an OLEDB Command transformation to do the update for you.
Exactly.. You use the lookup to find out if the record exists, there is a little bit...
September 16, 2009 at 1:53 pm
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...
September 16, 2009 at 12:15 pm
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
September 16, 2009 at 9:51 am
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...
September 16, 2009 at 9:45 am
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...
September 16, 2009 at 12:23 am
If I understand your request, add ", no_output" after @cmd..
CEWII
September 16, 2009 at 12:19 am
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...
September 15, 2009 at 8:53 pm
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
September 15, 2009 at 5:22 pm
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...
September 15, 2009 at 5:19 pm
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...
September 15, 2009 at 1:42 pm
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'),
-- ...
September 15, 2009 at 1:34 pm
Viewing 15 posts - 3,571 through 3,585 (of 4,272 total)