Viewing 15 posts - 5,416 through 5,430 (of 5,522 total)
Yep, that is it - once the drive is added as a resource for SQL Server, you can move the group to test.
I would also test by opening any dialog...
May 23, 2008 at 12:34 pm
What is Yosemite Backup? Is this something provided by your SAN vendor to perform some type of Snap/Snapshot backups on the SAN?
Anyways, all of these errors are being generated...
May 23, 2008 at 12:19 pm
What version of SQL Server do you have on the server?
What version do you have on your desktop?
You will get this error if you load the SSIS package onto the...
May 23, 2008 at 12:05 pm
Rob Symonds (5/23/2008)
May 23, 2008 at 11:56 am
Can't really answer that - it is something that you are going to have to test yourself to see if it does in fact slow the system down.
May 23, 2008 at 11:37 am
I am not sure if it checks the contents or uses information in the backupset table in msdb - however, it will not cleanup non SQL Server created files.
May 23, 2008 at 11:21 am
Msg 241, Level 16, State 1, Line 3
Conversion failed when converting datetime from character string.
When i do...
May 23, 2008 at 11:18 am
Okay, so lookup PIVOT and see if that will give you what you need.
May 23, 2008 at 11:12 am
Try modifying the linked server configuration and change the following server options:
Use Remote Collation
Change the first parameter from it's current setting (defaults to False) and try your query. ...
May 22, 2008 at 8:46 pm
It sounds like you want a crosstab - if so, lookup PIVOT in BOL. Generally though, this is much easier to do in whatever reporting tool you are using...
May 22, 2008 at 8:35 pm
What does not working mean? Are you getting an error? No results? Invalid Results?
May 22, 2008 at 8:23 pm
That is interesting - since everything I can find says that statistics on indexes will be rebuilt with a full scan.
May 22, 2008 at 12:45 pm
Are you running on AMD? If so, you can get a BIOS update from AMD to fix this issue. Work with your hardware vendor and/or AMD to get...
May 22, 2008 at 12:02 pm
The standard maintenance cleanup task will not remove files that are not native backup files. Since you are using a 3rd party backup utility (SQL Litespeed?), you need to...
May 22, 2008 at 11:55 am
If I switch from sysindexes to sys.indexes, I have no access to information as to how many rows in the index have been modified since the latest update. I need...
May 22, 2008 at 11:21 am