Viewing 15 posts - 6,271 through 6,285 (of 6,676 total)
What is the following parts of your query supposed to be checking?
WHERE @category = 'hardware'
AND @series = '1500'
AND @diameter = '5"'
...
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
July 29, 2008 at 2:33 pm
I am guessing, but that query definitely looks like something that would come from running a Profiler trace. If you were running profiler at the same time - that...
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
July 29, 2008 at 2:23 pm
Do you possibly have more data in live than in the test system? Are the statistics up to date on all tables involved in this 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
July 29, 2008 at 2:20 pm
rconway (7/29/2008)
Msg 156, Level 15, State 1, Procedure...
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
July 29, 2008 at 2:00 pm
Perry Whittle (7/28/2008)
alimcitp (7/28/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
July 28, 2008 at 9:44 am
The reason you are getting this error is because you are not using a GROUP BY query, so you can't use HAVING with a SUM.
It is not clear what you...
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
July 28, 2008 at 9:24 am
You can use
SET DATEFORMAT dmy;
Or, you can use CONVERT in the select statement. Date formats are usually better controlled in the client.
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
July 28, 2008 at 8:44 am
Dates are not stored in a format - this is controlled when you query the database and can be set using DATEFORMAT. The other option is to use CONVERT...
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
July 27, 2008 at 10:52 pm
Under Tools | Options | Designers there is a transaction time-out setting. It should be set to 30 seconds. You can try changing the timeout here and see...
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
July 27, 2008 at 10:33 pm
Look up aggregate functions in BOL. What you are looking for is a simple aggregate query using SUM and GROUP BY.
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
July 25, 2008 at 8:09 pm
Check out the system views sys.columns or information_schema.columns.
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
July 25, 2008 at 8:02 pm
What is your connection string? There is a 'feature' for SQL Server 2005 call User Instances that you may be running into.
If you are using AttachDbFilename in your connection...
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
July 25, 2008 at 12:59 pm
David Jackson (7/24/2008)
This works, but I still don't like...
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
July 24, 2008 at 12:01 pm
david.sims (7/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
July 23, 2008 at 5:31 pm
The backup files can have any name or extension you want. Using .bck will work fine and you won't have any issues with it.
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
July 23, 2008 at 4:55 pm
Viewing 15 posts - 6,271 through 6,285 (of 6,676 total)