Viewing 15 posts - 44,176 through 44,190 (of 49,571 total)
cuteprabakar (9/29/2008)
Tags??? How to setup this most of suggest set in new table???(max 10 tags with 20 characters length, previously I used space separated string)
In a separate table.
This will be...
September 29, 2008 at 1:18 pm
As in the example I gave, just make @currentyear a parameter rather than a variable.
September 28, 2008 at 6:00 pm
sal527 (9/28/2008)
and cyear=(cyear+1))
Well, that's never going to be true. A value is never equal to itself + 1.
Considering that you're hardcoding 2008 in the other spot, shouldn't that...
September 28, 2008 at 4:43 pm
Could the inner joins be filtering out the rows?
September 28, 2008 at 4:34 pm
It does look like someone (or several someones) is running a brute-force hack attempt against your serves. Can you speak to your network people, see if they can block ip...
September 28, 2008 at 4:34 pm
They will affect any query that tries to use the corrupt pages. Update stats (unless used with fullscan) samples pages, so it may or may not be affected, depending which...
September 28, 2008 at 3:25 pm
500kb of output even with no_infomsgs? Wow.
If the errors are in the base tables, and you have no clean backup, then your only option is to run checkDB with the...
September 28, 2008 at 2:45 pm
That could well be a hack attempt.
What's the previous line in the error log? (specifically the state?)
How strong is your sa password? If you're not using the account, can you...
September 28, 2008 at 1:07 pm
As for the first, I don't think that's logged.
For the second, query the sysjobhistory table in msdb. The amount of history depends on the frequency of the job. I think...
September 28, 2008 at 1:06 pm
john_izzy (9/28/2008)
how to make cursor in sql server 2005?
Why do you need a cursor? Unless you're doing certain types of admin tasks (which are often one object at a time)...
September 28, 2008 at 1:04 pm
Raghavender (9/28/2008)
CHECKDB found 0 allocation errors and 85 consistency errors in database 'DBNAME'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC...
September 28, 2008 at 12:55 pm
saby (9/26/2008)
September 28, 2008 at 9:12 am
The other thing I will suggest is that you consider moving the clustered index to the date column or the ID column (mainly because it will fragment less)
and put...
September 28, 2008 at 9:05 am
The first thing I will suggest is that you do an update stats with full scan on that table.
The execution plan shows that the optimiser is estimating 1 row and...
September 28, 2008 at 8:55 am
If you're able to upload the permon stuff, please not as a screenshot. There's not enough info in a screen shot. Zip and upload whatever you saved (if possible)
September 28, 2008 at 8:47 am
Viewing 15 posts - 44,176 through 44,190 (of 49,571 total)