Viewing 15 posts - 706 through 720 (of 1,315 total)
I think I understand what you're trying to do. What I was suggesting (and I haven't proven that this is the case) is that the package configuration is read in...
October 29, 2006 at 1:11 pm
First I would take the error message at face value and determine whether something running on the server can connect to your local SQLExpress. It may indeed not be configured...
October 27, 2006 at 1:09 pm
SQL 2005 has some better options, but I'll assume because this is a SQL 2000 forum that they don't do you any good.
If adding hardware is an option then go...
October 26, 2006 at 7:44 am
A literal transalation might look like this in a script task, but you might do better with a ForEach File container.
Imports
System
Imports System.Data
October 26, 2006 at 7:09 am
Great solution, but do you really think that list of "set @sql = @sql + ..." statements is readable? This isn't Visual Basic, you can use multiple lines in one...
October 25, 2006 at 4:50 pm
I fall into the category of "didn't look because I don't have a need for the product". If I was looking for something like it, I would fall into the...
October 25, 2006 at 4:08 pm
I track remaining free space per drive (from xp_fixeddrives) on my production servers by running a scheduled job on each server every four hours that adds the free space for...
October 20, 2006 at 10:12 am
DELETE works on individual rows, you can't use a HAVING condition directly. You would have to join the table to a grouped subquery. This might also be written as WHERE...
October 20, 2006 at 9:59 am
My biggest problem with the new maintenance plans is that the backup task resests the destination folder if you open it to modify other properties, such as the database list. ...
October 20, 2006 at 9:42 am
The prefix is necessary for the OBJECT_ID function, but not in DROP TABLE. This version doesn't generate any errors or warnings:
IF 0 < OBJECT_ID('tempdb..#a')
DROP TABLE #a
October 20, 2006 at 9:32 am
You've still got a zero column width in the fourth field (Surname).
The last two rows should be deleted.
October 20, 2006 at 9:19 am
One other thing, the last row of the format file should have the end-of-line sequence in the field terminator column (column 5). For example:
12 SQLCHAR 0 10 "\r\n" 0 SKIP Latin1_General_CI_AS
October 20, 2006 at 4:39 am
The second row of the format file should be the number of input fields (including skipped fields), or in other words the number of rows remaining in the format file. ...
October 19, 2006 at 11:35 am
In general, SQL Server will take all the memory it can get, mostly for caching data pages to minimize disk i/o. SQL Server tries to get along with the rest of the...
October 19, 2006 at 6:44 am
If you want SQL Server to work properly, you want as many local drives as you can get. You might want the OS and SQL installation plus the Windows swap...
October 18, 2006 at 3:29 pm
Viewing 15 posts - 706 through 720 (of 1,315 total)