Forum Replies Created
Viewing 15 posts - 36,751 through 36,765 (of 39,771 total)
-
RE: Security Context for SQL Jobs
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...
-
RE: Named Instance First
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...
-
RE: Databse in the DMZ?
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
-
RE: General Setup Best Practice
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...
-
RE: SQL Career Advice Needed
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
-
RE: Now an MDAC security question!
They are listed with all other pathches, jsut not included in SQL patches.
MS02-40 is one.
Steve Jones
-
RE: DBREINDEX and transaction logs
still logged, just runs in shorter transactions, so should prevent log fills.
Steve Jones
-
RE: SQL Career Advice Needed
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... -
RE: Data Extraction control and checks
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...
-
RE: Server-wide function?
I looked briefly, but couldn't find anything. I suspect you cannot do this.
Steve Jones
-
RE: SQL LiteSpeed - Lightning Fast Backups
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...
-
RE: OS Win XP
No idea there. I have very little on my XP machine. Try not to mess with the computer I need to work.
Steve Jones
-
RE: Application / Standard Roles
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,...
-
RE: OS Win XP
I run SQL 2000 Personal with no issues on XP Pro.
What compatability error?
Steve Jones
-
RE: Data Extraction control and checks
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...
). But we wouldnt' hire you on that cert. Experience is the biggest factor. If you...Viewing 15 posts - 36,751 through 36,765 (of 39,771 total)