Viewing 15 posts - 31 through 45 (of 70 total)
Hi,
Yes HowardW, you are correct - reseeding won't work because of the records and their relevant ID values that remain after the DELETE.
I was also thinking of the possibility of...
March 22, 2013 at 6:51 am
Hi,
Yes I am sure of the location and the file name and extension.
When I try doing the same from our QA server,it works fine, but from our production cluster, I...
November 14, 2012 at 12:52 am
There is a clustered index on this column and I have added an ORDER BY to confirm that IDs are skipped.
There are many constraints on this table as well.
What is...
August 26, 2010 at 2:32 am
There are definitely no other files on that drive besides the data files. I have no idea why this is happening.
There are not maintenance that would shrink a data...
May 13, 2010 at 2:31 am
Thought I would share with you all .... I resolved the issue.
It was the [LinkedServer] that used the SA login as the security credentials.
I replaced that with an alternative login,...
February 24, 2010 at 5:24 am
I found my problem - there was a space at the end of the DB name - silly me.
removed it - all worked fine
thanks
August 17, 2009 at 8:02 am
I managed to get the URL - here are the steps, should you be interested
Start - Control panel - Admin Tools - IIS - Expand Web Sites - Expand Report...
July 21, 2009 at 4:29 am
yeah I thought you might say that... 🙂
so this means I will have to restore a backup of the DB and then restore the log files after that?
June 9, 2009 at 8:27 am
I encoutered the same issue om my production server (SQL 2005).
To overcome the issue of receiving "failure notifications" from SQL Agent, I added 1 retry event under the Advanced properties...
June 8, 2009 at 5:23 am
Thank you for your info.
Another thing I was wondering about is this:
Will running Rebuilding indexes maintenance plan, decrease the number of deadlocks by any chance?
June 4, 2009 at 6:19 am
I checked the 'On success' action. Would have felt like an idiot if that was the case... But No, all settings are correct for on success and on failure.....
May 18, 2009 at 3:51 am
Thanks for your replies.
This also happens with my Transaction log backup files - a job that runs every 10 minutes.
It indicates that the Transaction log backup job has failed...
May 18, 2009 at 2:17 am
The request came in from a client. We provide them with an extract of the data in Excel format and then the records "repeat" as in my example.
They would like...
April 16, 2009 at 8:51 am
yeah i thought auditing would have to be the way out.
Just by the way - you said "if not too much time has passed" i can use the default trace....
March 30, 2009 at 8:16 am
Viewing 15 posts - 31 through 45 (of 70 total)