Viewing 15 posts - 6,571 through 6,585 (of 6,676 total)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 23, 2008 at 12:05 pm
Rob Symonds (5/23/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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.
You can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 23, 2008 at 11:21 am
gourab_sahoo (5/23/2008)
Msg 241, Level 16, State 1, Line 3
Conversion failed when converting datetime from character string.
When i do...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 23, 2008 at 11:18 am
Okay, so lookup PIVOT and see if that will give you what you need.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 23, 2008 at 11:12 am
Try modifying the linked server configuration and change the following server options:
Collation Compatible
Use Remote Collation
Change the first parameter from it's current setting (defaults to False) and try your query. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 22, 2008 at 8:35 pm
What does not working mean? Are you getting an error? No results? Invalid Results?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 22, 2008 at 11:21 am
bhanf (5/22/2008)
Not sure how to create a linked server (so my answer is no i...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 22, 2008 at 11:05 am
Well, I can say that I really do like SSMS a lot better than Enterprise Manager. However, some things that we got use to have either been removed -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 21, 2008 at 5:12 pm
Viewing 15 posts - 6,571 through 6,585 (of 6,676 total)