Viewing 15 posts - 91 through 105 (of 488 total)
I do not consider you geeks. I see this more as a very hot refining fire that will help me pay more attention to details and be more specific. From...
February 25, 2004 at 8:08 am
autoshrink can activate at bad moments (when many people are using the database) and so they will experience degraded performance. We have autoshrink on for most of our production databases,...
February 25, 2004 at 8:03 am
Well, I made an oversight again. I mentioned that you are using Enterprise Manager in the question but failed to change the correct answer to say Enterprise Manager won't allow...
February 25, 2004 at 7:52 am
create a table, perhaps called tblSPParameters with columns such as ParameterName varchar(30), ParameterValue varchar(30), SPName varchar(50), DateExecuted datetime with a default value of getdate(), and any other info you need.
Add...
February 24, 2004 at 7:38 am
No offense is taken. And I am not try to offend everyone by explaining my thought process as I created this question of the day. Recent comments help me to...
February 24, 2004 at 7:21 am
Try this:
CREATE TRIGGER trSendEmail ON dbo.TableName FOR INSERT
AS
EXEC master.dbo.xpsendmail @Recipients = 'myemail@mycompany.com', @Subject = 'Test'
February 23, 2004 at 8:22 pm
This was my first question of the day. I did my best to make it as clear as possible. I also counted on the fact that those who work with...
February 23, 2004 at 8:00 pm
I don't think I have ever reindexed system tables and doubt it is a good idea to do so. From what I have seen SQL Server system objects generally take...
February 23, 2004 at 7:09 pm
I'm not sure you can get the parameter values the way you are trying. I have never tried and don't know.
I will make some other suggestions. You can put a...
February 23, 2004 at 3:50 pm
You mean VBScripts won't work anymore. That won't be good. We use VBScripts in most of our DTS packages and for the reason you mention to get around DTS limitations. ...
February 23, 2004 at 7:46 am
It seems to me that the first part of the where clause is only meant to get one row. This modification might work:
WHERE EXISTS (SELECT Trans2.Parent_Record
FROM Sor_Order_History Ord2
...
February 21, 2004 at 9:05 pm
It will help me (and I believe others) to see the table structure, sample data for both tables, and the query used. Without seeing the query I might suggest things...
February 21, 2004 at 8:48 pm
I experienced problems with transfering objects and the only way I found to identify which objects were the problems was to remove them one by one or in groups and...
February 21, 2004 at 8:42 pm
A very nice article (and I only read half of it). I second the concern of how well will existing packages transfer to DTS in Yukon. Microsoft has made a...
February 20, 2004 at 2:28 pm
I just got through reading about the new DTS in Yukon. It sounds like it is as easy as 2000 if not easier.
February 20, 2004 at 2:24 pm
Viewing 15 posts - 91 through 105 (of 488 total)