RE: FTP Job Step Completing prematurely
I probably could but I would like to understand why this is happening. Sean
2004-07-20
backup
DTS and Oracle
Is it possible to retrieve data from an Oracle database (using DTS) without installing an Oracle client at the SQL-Server database-server ?It works fine whit the Oracle client installed; but we would like to avoid the installation of Oracle-stuff on our SQL-Server database-server.
2004-07-19
52 reads
RE: DTS - How to update records using DTS
If I understand you correctly:Use the ‘Transform data task’ to insert new rows and an update query in an ‘Execute SQL Task’ to update existing rows. Create a DTS package with ‘Execute SQL Task’ and ‘Transform data task’
2004-07-16
RE: finding out which stored procedures been modified in other database...
hello all,you may want to look at www.dbghost.com as well which the only true database change management solution for SQL Server available on the market today. Go to the site and read the white paper (a pdf download) as it makes for very interesting reading. Every shop should have this.Making the change is not change management, […]
2004-07-15
RE: Deleting with a Foreign Key
Thanks everyone for their input, I am going to try a bunch of options. Since this is an overnight process that crunches and rebuilds all the data, it's going to take me a week of change and analysis to see what works best. It's all part of the fun.
2004-07-09
2004-06-29
RE: about javascript and asp
what iam doing is enabling an forward option there is an internal email system in our web based ERP, and i cannot use querystring option to transfer data becoz text messages are too big some 2-3 pages of word files i know something like i can create a temp data at a client side and […]
2004-06-24
RE: How to fix "Divide by zero error" in SQL Server
Like Derrick Leggett mentioned, figure it out !If your investigation points the symantics are OK, then you might use a case statement .declare @col1 integer declare @col2 integer declare @col3 integer select @col1 = 8, @col2 = 0, @col3 = 2select @col1 / case when @col2 = 0 then 1 else @col2 end as first_division , @col1 […]
2004-06-24
3 reads
RE: how to change the QUERY to get todays timespent ??
Phile what can i say that worked beautifully Thank u very much
2004-06-17
RE: MMC GPFs Defining Transform Data Task
I have that question in to the SQL SA group. They may have changed something and not told us...I'll keep everyone posted.
2004-06-17
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers