Viewing 15 posts - 61 through 75 (of 80 total)
Running from QA this script will give you a list of tables for whatever DB you have in the dropdown in QA once for every DB in the query. Notice it...
December 22, 2005 at 8:08 am
Yep, a loop would work good. Doing the ";" delimited list wouldn't be a great idea is each person is suppose to get info unique to them. A while loop...
December 22, 2005 at 6:58 am
So you are asking to send an email to list of people? If you can get the list into a var (ie @emaillist) delimited by ';' then you can use...
December 21, 2005 at 3:54 pm
Thanks. Here is the script that finished. I'll have to give some credit to Andrew J. Kelly as I started with his script for CHECKDB but I wanted automated notification.
USE DBAstuff
SET NOCOUNT...
December 21, 2005 at 2:03 pm
I was wondering will dbcc checkdb raise an error that would abort a job? I would like to setup a script that will check all my DBs but want to...
December 21, 2005 at 7:42 am
If I'm working with a bunch of items I don't want a new tab for item I open. I want it to open in the query tab I already have open. ...
October 11, 2005 at 10:54 am
Here are the things I've done...
1) menu file, open, file, and open a file. Repeat and a second window will open.
2) basically same thing using the "open file" tool bar...
October 10, 2005 at 8:19 am
I'm using Dev Edition Sept CTP. I just checked again and it is working as I stated. I guess if it works the way I want it to for you...
October 10, 2005 at 7:19 am
Best thing I can think of is to just check out Microsoft's site and read the details of what you want to know about. I know it can be a...
October 4, 2005 at 2:43 pm
Only thing I can think of using the schema (took the place of owner) but that may not be what you want either. You could then click on the owner column...
October 4, 2005 at 2:40 pm
I would agree with the last person but would add SSIS (Integration Services). Much better if you do anything with files in DTS now. Heck, it's better if you do...
October 4, 2005 at 2:35 pm
Just thought info might make your day a little better. 35 miles of city driving would...well.. could suck.
August 31, 2005 at 1:29 pm
35 miles can't be right. I'll be at the Days Inn DFW and it's only 6.
August 31, 2005 at 12:48 pm
Was the party also at the summit or other location?
Sounds like a great way to let off some steam
August 25, 2005 at 2:59 pm
Viewing 15 posts - 61 through 75 (of 80 total)