Viewing 15 posts - 571 through 585 (of 1,583 total)
It is the job owner's account unless you enabled/specified a proxy account at the server level, and that's the same account running your Agent service.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2013 at 10:12 am
This may seem rather simplistic but you could try D-ECLARE @String char(17)
SET @String = ' =10 02=5608= '
SELECT LEN(@String) - LEN(LTRIM(@String))Perhaps create a simple scalar function to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2013 at 9:24 am
Fragmentation will occur (both within your databases and on the file system), and throughout the process it will cause some degree of contention, which depending on your system may impact...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2013 at 9:16 am
If your last checkdb fixed the data consistency errors and you took a full backup afterwards, that backup would be good (albeit, you may be missing some data). If...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2013 at 6:01 am
It's really "preference". Personally I like to segregate out my system stuff from the user stuff for my own peace of mind
I would recommend creating separate full backup &...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 5, 2013 at 7:54 pm
Probably more preferred to just select from the CTE where the RowNum = 1?SELECT * FROM dups d1
WHERE d1.RowNum = 1
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2013 at 10:16 am
I would create a simple function or just throw the results into a parameter table and loop through the spids, executing a kill command for each (you could also use...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2013 at 10:07 am
Great! Because I've already jumped another hundred visits since yesterday 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2013 at 9:54 am
Wow I am shocked (and a little angry). I did notice a change to the signature but had no idea that it was because the carpet had been yanked...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2013 at 5:55 am
If you have the option to add a new drive and initialize it, you could add the drive, take the old one offline, mount the new drive with the same...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 3, 2013 at 11:05 am
I was actually just wondering the same thing! In the past week or so I've noticed that the counter is incrementing every click to a new page (and not...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 3, 2013 at 9:44 am
What kind of disk subsystem is this server running on? SAN? Attached Storage? Internal drives?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 3, 2013 at 9:02 am
Issues resolved. Gail, I sincerely appreciate the guidance
Steps taken (I know I got lucky):
1. IT-added new drive to the array, rebuilt it
2. Dropped the article from the Publisher
3. Deleted...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2013 at 9:58 pm
I have also found that the battery on the RAID controller is having issues; but I wouldn't think that would cause it?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2013 at 2:40 pm
Will do, and thanks for the quick responses.
Heard back from IT, a new drive should be installed within the next 2-4 hours, then another few hours to get the data...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2013 at 1:23 pm
Viewing 15 posts - 571 through 585 (of 1,583 total)