Viewing 15 posts - 151 through 165 (of 221 total)
If you want to shrink the database and you can set up a maintenance plan and schedule it which will create the job. However, you ask about truncate log on...
November 26, 2001 at 2:39 am
November 21, 2001 at 11:10 am
If you're on SQL 2000 I'd use Steve's solution - the table variable - as it's easier and doesn't need any clearing up of a temporary table. Also, the temp...
November 21, 2001 at 8:06 am
Could use "select top 1 identitycol from Answers_Eligible" after the update
Paul Ibison
November 21, 2001 at 2:13 am
You could store the results of the ExecuteSQL task in a recordset and loop through the recordset in the package. (Peterson's book explains how to set up a loop in...
November 20, 2001 at 6:22 am
For input formats, have a look at SET DATEFORMAT in bol. This changes the interpreted format of text dates when entered into datetime variables/columns. Otherwise I think the language setting...
November 20, 2001 at 3:24 am
Interesting - never thought of this as a discrepancy before. However, I suppose there is a distinction. In the case of "Select @column, col1 from Table" the @column is not...
November 19, 2001 at 5:31 am
I guess it's because @table will be interpreted as the name of a table itself, rather than a variable holding the name. So if you didn't have a table called...
November 19, 2001 at 5:18 am
Don't know if it will be suitable for your case, but there is a simple way of doing this. You could login users of your application using an sp. This...
November 19, 2001 at 4:20 am
You could construct the slq text as a string and use: EXEC("sqlstring") or sp_Executesql.
Alternatively you could use a user defined function, which can be used in l=place of a tablename...
November 19, 2001 at 2:56 am
It sounds like the whole sql statement needs to be treated as dynamic. In this case, I'd look at using a AcxiveX task to reassign the sql text before the...
November 19, 2001 at 2:47 am
Tthere is not an automatic method I know of to do the whole db, and even if there was a system sp, I guess it would still have to iterate...
November 19, 2001 at 2:43 am
Have just mimiced this on my work system, and found I needed to check Dynamically Determine Port - hope this helps.
Paul Ibison
November 16, 2001 at 11:02 am
Not 100% sure, but I think the port number won't be 1433. Have a look on the server to see what it's using.
Paul Ibison
November 16, 2001 at 10:58 am
The difference of fillfactor or none depends on the initial create index statement. As your index increased in size (1MB -> 2MB) when you ran DBCC DBREINDEX - no fillfactor,...
November 16, 2001 at 5:22 am
Viewing 15 posts - 151 through 165 (of 221 total)