Viewing 15 posts - 36,751 through 36,765 (of 39,771 total)
Probably. Wehn you run sp_Start_job or click EM, you execute the stored procedure in your context, which executes the job.
If you let the schedule kick it off, that thread is...
December 17, 2002 at 8:33 am
Haven't tried this and not sure it should matter, but an interesting issue.
I did the client tools on my laptop, then personal later and it wouldn't let me do a...
December 16, 2002 at 3:52 pm
That's what we do. Most likely the network guys didn't think of it or couldnt' get it talking and chose the easy way out.
Steve Jones
December 16, 2002 at 3:49 pm
Generally you want to follow Scorpians advice, but I've put both on a single server.
The things you do want to do, however, is not limit your flexibility. Don't connect with...
December 16, 2002 at 3:46 pm
I would hire you with or without the cert as a junior. Doesn't mean much to me, though it does show some initiative.
Steve Jones
December 16, 2002 at 12:51 pm
They are listed with all other pathches, jsut not included in SQL patches.
MS02-40 is one.
Steve Jones
December 16, 2002 at 11:39 am
still logged, just runs in shorter transactions, so should prevent log fills.
Steve Jones
December 16, 2002 at 11:38 am
Here we require the MCDBA (course, I don't have mine yet,
). But we wouldnt' hire you on that cert. Experience is the biggest factor. If you...
December 16, 2002 at 9:49 am
Are you extracting to a staging table? Some perm table that you use to hold the data prior to posting.
Once in here, I'd use T-SQL to get the records in...
December 16, 2002 at 9:45 am
I looked briefly, but couldn't find anything. I suspect you cannot do this.
Steve Jones
December 16, 2002 at 9:31 am
They are working on a maint plan replacement and some other enhancements. I'm expecting (and excited) to see them soon, so I'll let you know.
Since we use Diff's anyway, the...
December 16, 2002 at 9:24 am
No idea there. I have very little on my XP machine. Try not to mess with the computer I need to work.
Steve Jones
December 13, 2002 at 2:04 pm
I'm sure Andy will chime in soon. This is his baby, but if you use std or integrated security, those users can access your db with any tool, excel, Access,...
December 13, 2002 at 2:03 pm
I run SQL 2000 Personal with no issues on XP Pro.
What compatability error?
Steve Jones
December 13, 2002 at 9:49 am
I'd build a DTS package to extract these. Is this SQL 2000? If so, the dyanamic properties task can be used to easily find the date from a table or...
December 13, 2002 at 9:45 am
Viewing 15 posts - 36,751 through 36,765 (of 39,771 total)