Viewing 15 posts - 136 through 150 (of 205 total)
I am not aware of any changes to the SA account. The standard for it here is assign it a 50+ character complex PW and forget about it. No one...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 9, 2009 at 8:40 am
Ed, I do believe you are on to something, but I experienced the same problem with adding "Domain Admins" to the server with the SysAdmin role, the next day. I...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 30, 2009 at 11:40 am
Hey, I remember that. I started administering SQL Server with that version. So, yes, I have used it, and every version after it.
If you have a question about it, I...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 29, 2009 at 11:44 am
I am trying to get another server for working out this problem set up now. The original server where this problem exists is needed for an important project so I...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 29, 2009 at 8:41 am
I see the job history just fine, it's the step results that ar emissing. In my job definition I have selected an output file, and have selected to include step...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 8, 2009 at 5:50 am
nataliehinnen (4/29/2009)
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 29, 2009 at 1:52 pm
It sounds like you just need to set up alerts in SQL Server. These do what you describe in your posts.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 29, 2009 at 8:15 am
For large files, I have found WinRAR to be a better option than Winzip. Perhaps it does now, but when I started needing this Winzip could not handle a file...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 28, 2009 at 1:37 pm
Semi-colon (;) between addresses will do it.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 28, 2009 at 10:51 am
My solution for this, in the many cases I have run into in the past, is to restore the nightly backup of said DB to another DB on the same...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 28, 2009 at 8:05 am
I agree. The server is likely trying to recover a database. Depending on what it is trying to recover from, uncommitted transactions or from corruption, and the size of the...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 24, 2009 at 11:42 am
I always script the user from the Prod environment and run that script on the test or dev environment to copy the users then I never have to mess...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 22, 2009 at 5:50 am
Who did you buy PGP from? Can they provide support? I have used "GPG" in the past for this sort of thing and have never encountered a problem. GPG is...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 21, 2009 at 7:32 am
This is what's so mysifying about the situation. It rolled back, even though the script completed with no error messages, and the script had specific "Commit Tran" statements in it,...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 16, 2009 at 5:35 am
After 2 hours, 53 minutes, the restore finally finished and now the transaction log is almost empty. Time for a shrinkfile.
The shrinkfile worked, on both data and log files. So...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 15, 2009 at 1:44 pm
Viewing 15 posts - 136 through 150 (of 205 total)