Yes, I think triggers on system tables can be useful in some cases. At the very least Microsoft could provide some triggers in an inactive form that could be...

I knew I was likely to get various negative comments to this article. It isn't inteneded to be as serious as the others I have published. Please forgive...

This is the way this DTS package evolved. I have recently learned that I can use a VBScript before each data pump gets executed to determine if it will...

I think making a book out of articles is a good idea and I would consider buying one. It could also generate added insentive for people to submit articles...

I have found that the error log will log the step name not the task name. Also, I can rename the step without renaming the task and thus avoid...

I never knew about that. This looks to be promising for other things, however I don't see timeout options for an ActiveX Script task. I see them for...

This is how I write to the eventlog when executing SQL in my DTS packages. As long as it doesn't interfere with the code you need to execute then...

This is part of a complex DTS package and is needed. I recently converted it from an Execute SQL Task to the ActiveX Script Task to take advantage of...

I've been looking at this problem and have just discovered that if I drop the primary key from a table I can't design in EM, then I can design it.

We get the same error from various workstations and from the server itself.

Also when I run this query:

SELECT f.SID,f.FID, getdate()

FROM tblDeleted d

INNER JOIN SQLServer1.dbDataBase.dbo.tblSF f ON f.FID = d.INum

WHERE Deleted...

We use linked servers and use them in stored procedures. We simply sript out all the sp's we plan to move and do a find and replace to change...

Here are some typical commands as sent by the Index Tuning Wizard:

dbcc autopilot (1, 19, 718625603, 1, 0)

dbcc autopilot (6, 19, 718625603, 1, 1, 0, 10)

I suspect one of these...

Me too. Also if you set Query Analyzer to show the execution plan you won't get one when using the autopilot commands which seems to support the fact that...

I did some more investigating and found out that I got that error because I didn't ever try to execute DBCC autopilot which seems to do something when I execute...

After the initial login to the workstation, does any authentication go to the PDC when connecting to SQL Server or does it all stay local?

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading...