Viewing 15 posts - 20,821 through 20,835 (of 39,961 total)
Dave Ballantyne (2/19/2010)
Steve,save us all the trouble and
Select * from posts where Thread = 'the thread' and message like '%smith%'
😀
Yeah, ummm, hmmmm, I think I'll pass. Not sure I want...
February 19, 2010 at 1:11 pm
I'd go to SP3. Sp2 had some issues early on and some hotfixes.
Haven't seen any issues, at least major ones, with Sp3
February 19, 2010 at 10:23 am
Go to a job step, properties, advanced. There are places to log, including a table. you can specify a file or a table.
If this is a maintenance plan, the plan...
February 19, 2010 at 9:51 am
I would double check this with the admins, as Lynn mentioned. I might also try to add the user to a Windows folder with permissions and make sure that box...
February 19, 2010 at 9:37 am
If you manage your file size and grow discretely, you don't need to do this often. Diskeeper works, but I've done this once a quarter or less with the built...
February 19, 2010 at 9:34 am
First, you need to realize that SSMS != SQL Server. SQL Server is a server service that starts up independently of SSMS.
SSMS is a program, like notepad. You can run...
February 19, 2010 at 9:07 am
Well written, Gary. Your brother is lucky to have you around.
February 19, 2010 at 8:59 am
I use separate packages for system backups. These maintenance plans have always worked well for me, and having them in separate packages allows me to run a separate set of...
February 19, 2010 at 8:54 am
I think the system usage is a definite factor. However the majority of updates/patches I've done always took place at night when there was plenty of time to fix things....
February 19, 2010 at 8:39 am
I'd probably choose a non-user account. Create one specifically for jobs on that instance to run under.
February 18, 2010 at 12:30 pm
The award is annual, but they award 4 times a year. So if you are awarded in April, you are an MVP until next April, when you get renewed or...
February 18, 2010 at 11:06 am
I've tried to clean things off many Fridays, and it's a great policy. However a few places I've worked designated Fri night as release night as most of the world...
February 18, 2010 at 10:51 am
Signal : noise is getting worse in some ways. More people trying to be MVP or show off, so there's more participation.
Just like with anything, as more people participate, the...
February 18, 2010 at 10:49 am
PASS has also been good about moving registrations for a company if someone leaves or can't attend.
If you haven't been to Seattle much, there are cool things to see. Might...
February 18, 2010 at 10:47 am
Viewing 15 posts - 20,821 through 20,835 (of 39,961 total)