Viewing 13 posts - 1,306 through 1,319 (of 1,319 total)
DTS data resides in msdb, so if that's being backed up, you should be fine.
-- You can't be late until you show up.
February 21, 2008 at 10:16 am
Forgive me for speaking about SQL 2000 in this forum but that's what were running here. When we would replace servers, there is a table in msdb called sysjobs. By...
-- You can't be late until you show up.
February 21, 2008 at 8:37 am
DOH! sp_configure returns all the characteristics of SQL. Amazing how much your mind begins to atrophy when your not using the tools!
-- You can't be late until you show up.
February 20, 2008 at 10:09 am
Gary, A lot more detail is needed for anybody to attempt to help you. Such as:
1) What are you trying to duplicate, certain rows of data or entire tables?
2) What...
-- You can't be late until you show up.
February 20, 2008 at 8:55 am
At the server running MSSQL go to Control Panel->Admin Tools-> Services. Find MSSQL (and any related SQL services running on the server, if needed) and double click the service. Go...
-- You can't be late until you show up.
February 20, 2008 at 8:14 am
Cool, thanks. I was just going to download it. I appreciate the quick responses.
-- You can't be late until you show up.
February 19, 2008 at 2:20 pm
Sorry, I thought these only pertained to SQL 2005. I used these at my last company which had several 2005 installations and for freebies, thought they were great starting points...
-- You can't be late until you show up.
February 19, 2008 at 2:10 pm
I haven't seen it crash a server. I've seen an application be affected, of course. Did you contact Microsoft? When we had consistency errors, we were able to simply rebuild...
-- You can't be late until you show up.
February 19, 2008 at 8:31 am
Any tape sweeps of the files running at this time? That one has got me a few times in the past where infrastructure was running automated tapes sweeps of my...
-- You can't be late until you show up.
February 14, 2008 at 9:02 am
This may sound crazy but did you apply the service pack on the client machines? I once was bit by this years ago. Different clients, running different versions of the...
-- You can't be late until you show up.
February 14, 2008 at 8:23 am
Thanks anyway. Found my answer. Amazing some on the things you can find in BOL!!:rolleyes:
-- You can't be late until you show up.
February 13, 2008 at 2:50 pm
Is there an easy way to do it? I have around 100 packages on one server and I'm, of course looking for the easy way around it as opposed to...
-- You can't be late until you show up.
February 13, 2008 at 2:00 pm
Lowell,
That worked perfectly. I do wonder how the case statement works as I am not seeing the valuew in your evaluation but it does come out with true values where...
-- You can't be late until you show up.
February 13, 2008 at 12:04 pm
Viewing 13 posts - 1,306 through 1,319 (of 1,319 total)