Viewing 15 posts - 1,441 through 1,455 (of 1,583 total)
No problem! I sincerely hope the tsql code helps.
Like yourself, I haven't dove in to the powershell much yet...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 24, 2011 at 4:27 pm
http://msftdbprodsamples.codeplex.com/releases/view/37109
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2011 at 9:51 pm
Can you post the code and sample data?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2011 at 9:44 pm
I think you may have misunderstood...(or maybe I did) but you asked:
I have a 100 + Jobs running on our production SQL server and these jobs are running/owned under service...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 22, 2011 at 2:19 pm
Viewing 15 posts - 1,441 through 1,455 (of 1,583 total)