Viewing 15 posts - 1,441 through 1,455 (of 1,584 total)
Did you ever get a fix for this? When attempting to do a similar thing I get the exact same error (on a 32-bit system)
September 6, 2011 at 10:39 am
No problem! I sincerely hope the tsql code helps.
Like yourself, I haven't dove in to the powershell much yet...
September 1, 2011 at 6:03 pm
You can try something like the code below (this is assuming you've already performed any full/diff backups):
/* LOADS ALL TRN FILES IN A GIVEN DIRECTORY AND THEN RESTORES THEM TO...
September 1, 2011 at 1:46 am
I am using SQL 2008 EE, and do not see a checkbox for 'Reinitialize'...
I have only buttons to Start, Stop, Monitor, and Close
I will try the TSQL...
August 30, 2011 at 8:00 am
It's always neat to see the different ways things can be efficiently accomplished. I like your script Perry! Simple.
August 30, 2011 at 7:47 am
What kind of locks? Were you able to determine the head/lead blocker(s)? Do you have a profiler trace available?
If you don't have any of those things begin with the...
August 29, 2011 at 10:45 pm
Not the best approach (using xp_cmdshell) but you could try something like this (it should work just fine, provided your proxy account is able to delete files off the file...
August 29, 2011 at 4:50 pm
You should have the Microsoft SQL Server Business Intelligence Development Studio already installed (if you have the Client and Connectivity Tools installed on your machine from when you installed...
August 29, 2011 at 10:32 am
To create/edit/deploy SSIS packages you will need to have BIDS (Business Intelligence ..etc) installed on the machines you wish to develop on. From there you can build and test...
August 29, 2011 at 9:43 am
I'd agree with NJ-DBA...use SSIS and schedule your dtsx as a schedule SQL Agent job that you can then trigger your reports from. However, as a simple test you...
August 26, 2011 at 2:27 pm
Should work just fine with the hyphen (especially if you use the scripts provided by Lowell and others).
You can also create an ODBC connection on the OS-level (giving it a...
August 26, 2011 at 2:11 pm
I have noticed that I do NOT get the error when writing the file out to a local drive...
Ex:
SET @cmdrun = 'rs.exe -e Exec2005 -s http://OURSERVER/reportserver -i "C:\FTPFILES\RSSFile\SSRSReportsCSV.rss" -v vFilename=D:\Sales_Performance.csv...
August 24, 2011 at 5:25 pm
You can create an Event Handler and deal with it that way but if I understand your question correctly, you should be able to go into your OLE DB control,...
August 24, 2011 at 4:27 pm
Viewing 15 posts - 1,441 through 1,455 (of 1,584 total)