Viewing 5 posts - 46 through 50 (of 50 total)
Provided you're not on a live production db, this may suffice, depending on structure of your db/constraints:
-- Turn off refer integ on a table
ALTER TABLE [TableName] NOCHECK CONSTRAINT ALL
ALTER TABLE...
June 11, 2009 at 1:58 pm
...I beleive these are ragged right formatted files...
To get this to work you really hafta know the structure of the file. What are the delimiters?; are there file headers...
June 11, 2009 at 11:22 am
Here's a template for a generic cursor. See BOL for details.
-----------------------------------------------------------
-- to reduce traffic don't bother with display of row count
set nocount on
-- define the cursor --
declare @object...
June 11, 2009 at 10:36 am
- Open Management Studio
- In the Object Explorer pane, expand SQL Server Agent
- Right Click 'Jobs': choose 'New Job...'
- On General Page: fill in Name field: "Job Whatever"
- On Steps...
May 11, 2009 at 3:03 pm
UltraEdit
May 11, 2009 at 10:38 am
Viewing 5 posts - 46 through 50 (of 50 total)