Viewing 15 posts - 37,291 through 37,305 (of 39,511 total)
Simple enough. Check the day (using datepart) and setup a case statement that will add 5, 6, 7, 8 days to the date to skip weekends.
Steve Jones
June 27, 2002 at 3:32 pm
the easiest way to do this is with an identity. For this, you would need to specify it when you create the table
create table tgt_pick_list
( pick_list_no int identity(1,1)
,...
June 27, 2002 at 2:42 pm
Only if they administer the domain (Add users, permissions, etc.). Otherwise, no.
Steve Jones
June 27, 2002 at 2:38 pm
June 27, 2002 at 1:12 pm
June 27, 2002 at 10:48 am
Or if you want a single output file, check out my Version Control Series.
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
June 27, 2002 at 10:43 am
Can you use multiple packages? One that determines what to do and calls another? Or multiple steps in a job?
Steve Jones
June 27, 2002 at 10:42 am
Restore from backup or recreate. The DTS pacakges are somewhat fragile and when they break, they be BROKEN!
A good reason to keep a .dts backup of your packages.
Steve Jones
June 27, 2002 at 10:40 am
The suggestion above does a script. If you need more of a document, then ErWin (from ca), ER/Studio (Embarkadero) and others will reverse engineer and develop some documentation. Total SQL...
June 27, 2002 at 10:37 am
June 27, 2002 at 10:35 am
sp_helpdb has some of these.
I'm guessing these are properties of the database, maybe an extended properties seting.
Is this SQL 7 or 2000?
Steve Jones
June 27, 2002 at 10:33 am
1. Setup a role first. Then give a user for this role to the developer, it should be an easy item they enter once and reference. You should be able...
June 27, 2002 at 10:28 am
Checkpoints are used to mark items in the log that are flushed out. It will consume some CPU and IO, but most of the time it will sleep. It's a...
June 27, 2002 at 10:22 am
The plan has the "all databases" checked or another option?
If it's doing this, I would recreate the plan. It's simple and would likely solve the issue.
Steve Jones
June 27, 2002 at 10:20 am
sp_configure gives server settings
sp_helpdb gives a bunch of db specifics. What are you looking for that is not covered?
Steve Jones
June 27, 2002 at 10:18 am
Viewing 15 posts - 37,291 through 37,305 (of 39,511 total)