Viewing 15 posts - 1,096 through 1,110 (of 2,486 total)
Probably the main cause is DTS. If you store your DTS packages in SQL Server and edit them frequently you can end up with dozens of versions of each package....
June 26, 2005 at 10:39 pm
How about you ask your question over at http://www.asp.net ??
June 26, 2005 at 4:35 pm
You can not use a UDF as specified in your first example in the ExecuteSQL task. This is because the meta data about the parameters is not available.
Call your...
June 26, 2005 at 8:46 am
Ann
The time, effort and resources you expend backing up, and possibly restoring, the system databases is vastly outweighed by the consequences of not doing it. I'm of the opinion that...
June 22, 2005 at 4:20 pm
Sounds like the infamous DLL versioning problem. The DTS SMTP Mail task is expecting a procedure to exist in the DLL but it doesn't.
Haven't played with that custom task myself, I just...
June 22, 2005 at 4:16 pm
I agree, passwords should be written down. This is especially true for IT staff for DR purposes and in the event that you're not around when the password is needed, like...
June 21, 2005 at 9:49 pm
DTS packages reside in the msdb database. So they're backed up when you backup the msdb database (you do back it up regularly don't you ?? )
If you want to...
June 21, 2005 at 9:39 pm
Best bet is to change your Print statements to insert the text into a logging table.
June 21, 2005 at 9:35 pm
Rather than repeat verbatim here, check the relevant topics in Books Online.
For starters try these,
Table and Index Architecture
Index Tuning Recommendations
Query Tuning
June 20, 2005 at 4:56 pm
As an example of whats possible, I use this following function to email me reports about failure messages from my maintenance routines. At the end of the maintenance, if an...
June 18, 2005 at 10:57 pm
Store the information from the form into a table in the database.
Create a stored procedure to format the data required in the body of the email into a string with...
June 17, 2005 at 2:15 am
You'll have to go down either path a, b, or something very similar.
You could obfuscate your table names and do all the data retrieval and processing in your client app....
June 17, 2005 at 2:03 am
No don't add a lookup. The lookup would only be used as part of the datapump and therefore switch it to row-by-row mode which would slow down your entire data...
June 16, 2005 at 4:57 pm
I think a change is needed.
With the release of SQL Server 2005, I think the forums should be organised as per the product toolset.
eg:
Management Studio
-- General Administration
-- Security
-- Replication
-- Notification...
June 16, 2005 at 4:43 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,486 total)