Viewing 15 posts - 46 through 60 (of 90 total)
Good question, I'll look into which ones. Thanks!
June 20, 2011 at 4:12 pm
The database is about ~750MB.
June 20, 2011 at 3:46 pm
Found the resolution to this.
- The user needs to have the public role in the master database, explicitly mapped.
- Run the following command: Grant Execute on sys.xp_prop_oledb_provider to [login];
May 3, 2011 at 10:05 am
Thank you David, yes I had to declare @rowid and @sqlstr.
January 26, 2011 at 2:21 pm
Thank you Steve, that resolved my issue 🙂
January 20, 2011 at 1:46 pm
I checked and the instance is running under the "Network Service" account. This server is on the DMZ not on the domain so I can't use a domain account....
January 20, 2011 at 10:45 am
Gial, how would I know if SQL has full control over a folder? NTFS permissions state that I have admin privileges for the same windows domain account which is...
January 20, 2011 at 10:39 am
Geoff, my main concern is not necessairly immediate monitoring but performance analysis over time. I want to be able to consolidate some of my SQL servers and I need...
January 11, 2011 at 11:39 am
Yes all the servers I'm looking at are 2005.
October 4, 2010 at 8:15 am
One simple thing to check is what version(s) of MSSQL are you running. I've had problems saving/editing maintenance plans using the 2008 management studio with SQL Server 2005.
You could...
September 15, 2010 at 9:26 am
paul.knibbs (8/20/2010)
chrisph (8/18/2010)
August 23, 2010 at 1:08 pm
Steve, do you think there are any other issues in regards to storing large files about 1MB other then performance?
August 18, 2010 at 3:42 pm
Thank you Steve. So what you are saying is this option is feasible but must be selective. For instance we could save space by converting a 50MB PDF...
August 18, 2010 at 10:08 am
Thanks, I'll create individual tasks in that case.
July 20, 2010 at 12:53 pm
Hi Steve,
I am on MSSQL2005 SP2 and the only option I see similar to what you described for the Maintenance Cleanup Task is "Include first-level subfolders" but I would like...
July 20, 2010 at 8:08 am
Viewing 15 posts - 46 through 60 (of 90 total)