Using DBMS-features like foreign keys, check constraints, defaults, unique keys, etc. as some sort of "last line of defence" to my opinion is crucial whenever designing/maintaining a database system, especially in...

hi, the behavior you experience is absolutely by design and no mystery. if you take a close look at BOL, you'll recognize that stored procedures NEVER required BEGIN and END...

hi & thanks. stupid me found this 10 mins after my posting. but anyway, i simply cannot understand why they're adding two additional clicks to get real overview of jobs...

You could also achieve this result by a simple Shell script using RegEx-Replace and an ActiveX task before the actual transformation (dealt successfully with such things before)

oh come on! not the biggest secrets here but nevertheless. once you don't live in anglo-american regions, you'll be in deep shit with date-format, decimal-delimiting characters and so on.

ever thinking...

hi!

you'll have to set the CommandTimeout property of your connection. ConnectionTimeout property just relates to the actual build-up of a database connection, whereas CommandTimeout sets the time-out for each command...

hi!

basically your IE doesn't come up because there's no handle for visual support available when running a stored procedure in the SQL server process.

in general i must admit that what...

hi!

you don't even need VBS to test an ADO connection. just create a file with arbitrary name and ".udl" extension ... double-click it to bring up the standard ADO connection...

hi!

if you want - of course this involves some t-sql experience - you can do it using loop for transferring chunks of a specific size by using:

insert into ... select...

hi!

not to my knowledge. only thing you can do is choosing means of transfer for the initial snapshots you'll need (eg. UNC paths, FTP servers, etc).

best regards, chris.

hi!

have a look at: http://www.sqlservercentral.com/scripts/contributions/246.asp

best regards, chris.

hi!

try turning on MS DTC (distributed transaction coordinator) on your SQL server machine.

best regards, chris.

hi!

i wouldn't use an execute SQL task for that (don't even know if that is possible at all).

create and active-x script task instead. connect to your ORACLE database by using standard...

hi!

hope i got your question right. normally, when designing your database, you'd use a numeric field as your primary key in that case. this prohibits entering anything else but digits.

once...

hi!

see "Using @@ERROR" chapter in BOL. @@ERROR will help you checking execution result of your SQL statements in your stored procedure and react to error conditions occuring there.

best regards, chris.