Viewing 15 posts - 2,611 through 2,625 (of 2,635 total)
Run this script and save the results before you run the 'drop' script.
select 'ALTER TABLE ' + cast(t.name as char(30)) + 'ADD CONSTRAINT '
...
December 18, 2003 at 3:53 pm
How about this?
select 'ALTER TABLE ' + cast(table_name as char(30)) + 'DROP CONSTRAINT '
+ cast(constraint_name as char(50)) + char(13) + 'go' +...
December 18, 2003 at 9:47 am
You should either use a Data Driven Query task with an insert query or an Execute SQL task with an insert query.
The insert query should look something like,
/*Insert...
December 18, 2003 at 9:20 am
You'll need to add an Execute SQL Task to your DTS package that disables or drops the FK constraints i.e. ALTER TABLE with CHECK/NOCHECK CONSTRAINT. Here's a script to...
December 17, 2003 at 12:30 pm
Do you want to use the VB front end and eliminate Access altogether (sounds like option #3)? If so, I recommend using DTS to move the database from Access...
December 16, 2003 at 11:45 am
Once again, the typo (articleid) in the email is corrected (article_id) on the web page. This has happened enough times that I always go to the web page to...
December 16, 2003 at 10:01 am
Oh man, I feel for you. Some of my longest days have been spent trying to configure Oracle.
Hope the book helps!
December 10, 2003 at 3:14 pm
sp_cycle_errorlog will close the current error log and open a new one without restarting SQL Server. See "sp_cycle_errorlog" in BOL.
Greg
December 10, 2003 at 10:19 am
I don't know of any utility that can translate the export file into SQL Server. As far as I know, an export file can only be read by the...
December 10, 2003 at 10:04 am
Syslogins is a view in the Master database that selects from sysxlogins table. Curiously, BOL refers to syslogins as a system table.
December 10, 2003 at 9:08 am
Yeah, the online courses should get you started. Some good books to consider are "Oracle DBA Survival Guide" (SAMS), "Oracle DBA Handbook" (Oracle Press), and "Oracle Backup & Recovery...
November 17, 2003 at 2:46 pm
We've never had a problem restoring a MSSQL7 backup to a MSSQL2K database. It's one of the supported methods for upgrading from v7.0 to v2000. See Knowledge Base...
November 17, 2003 at 10:24 am
I started working with SQL Server after being an Oracle DBA for a couple of years. My Oracle responsibilities have declined over the past 3 years as our databases...
November 13, 2003 at 12:35 pm
Have you enabled logging to msdb in the package? That's always allowed me to view details of a package error.
November 13, 2003 at 11:01 am
Check Visible Analyst from Visible Systems.
October 28, 2003 at 9:44 am
Viewing 15 posts - 2,611 through 2,625 (of 2,635 total)