Viewing 15 posts - 1 through 15 (of 113 total)
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...
March 2, 2006 at 2:32 am
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...
February 22, 2006 at 1:35 am
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...
February 17, 2006 at 8:28 am
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)
January 10, 2006 at 2:20 am
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...
October 27, 2005 at 1:52 am
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...
January 23, 2004 at 6:52 am
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...
January 23, 2004 at 6:47 am
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...
January 23, 2004 at 6:42 am
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...
January 23, 2004 at 6:36 am
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.
January 16, 2004 at 5:33 am
hi!
have a look at: http://qa.sqlservercentral.com/scripts/contributions/246.asp
best regards, chris.
January 16, 2004 at 5:13 am
hi!
try turning on MS DTC (distributed transaction coordinator) on your SQL server machine.
best regards, chris.
January 16, 2004 at 4:54 am
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...
January 14, 2004 at 10:04 am
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...
January 14, 2004 at 9:36 am
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.
January 14, 2004 at 9:24 am
Viewing 15 posts - 1 through 15 (of 113 total)