Viewing 15 posts - 4,231 through 4,245 (of 6,397 total)
No one will do anything until you provide us with consumable DDL, sample data, expected results and what you have used so far.
Again as with the other topics follow the...
July 20, 2012 at 3:56 am
How many topics do you need to start for the same question
http://www.sqlservercentral.com/Forums/Topic1332708-392-1.aspx
http://www.sqlservercentral.com/Forums/Topic1332029-392-1.aspx
http://www.sqlservercentral.com/Forums/Topic1332694-392-1.aspx
Keep everything in the same topic,
Do not start new topics for the same question, you get fragmented replies
July 20, 2012 at 3:32 am
SSRS is Windows based authentication only, you will need to use something like impersonation or custom authentication providers to do something like that.
July 20, 2012 at 2:06 am
Deploy all reports to a folder which is locked down so the end users cannot see the folder.
Then create a linked report to the primary report in a folder where...
July 20, 2012 at 2:03 am
Server wide DDL triggers, traces, extended events etc etc.
Depends what you want to track.
Please elaborate furthre for a more consise answer.
July 20, 2012 at 1:59 am
I would extract the dtsx files from the filesystem and load them into MSDB and change the job to point to the database instead of the fileserver. But thats...
July 20, 2012 at 12:55 am
Hi.
This is primarily an English speaking site.
I have done a Google translate and it seems like you are having errors with DTS in SQL 2000 when running as a job.
Can...
July 19, 2012 at 8:08 am
SSIS is not cluster aware.
Always save to MSDB and never to the file system, that way the packages move with the SQL service and dont stay on disk.
July 19, 2012 at 7:56 am
In the BINN folder is MsDTSSrv.ini.xml, open that in notepad and where it sales file system it should have storepath as somethng like ..\packages, that will tell you where the...
July 19, 2012 at 7:28 am
You would need something like AD Change Auditer from Quest to get that sort of information. http://www.quest.com/changeauditor/
There is no way in SQL or via AD that I am aware to...
July 19, 2012 at 7:11 am
error in the parameters used to drive the report, error in the data, error running the report, error creating the file, permission errors?
can you run the report manually for all...
July 19, 2012 at 6:00 am
what is the error?
July 19, 2012 at 5:50 am
Viewing 15 posts - 4,231 through 4,245 (of 6,397 total)