We use temp tables and derived tables and the queries and stored procedures that use them run fast. I prefer derived tables as this avoids a bottle neck in...

Thanks for the help so far.

For us this is a tough one. Originally we had the 7.0 client tools. The upgrade to the 2000 tools failed...

We could view Event Viewer and don't know what thie Manage is.

We uninstalled SQL Server client tools and reinstalled on our terminal server. We still have the same problems,...

Will this do what you want:

DECLARE @KeepMonthsInDatabase varchar (12)

DECLARE @ProcessTable varchar (30)

DECLARE @SelectedColumn varchar (30)

DECLARE @str nvarchar (255)

SET @ProcessTable = 'Transactions'

SET @KeepMonthsInDatabase = '3'

Print @KeepMonthsInDatabase

SET @SelectedColumn = 'transactionDatestamp'

SET @str =...

We have transactional replication now (in SQL Server 7.0 SP 3) and have a few tables with triggers on them. We haven't had any problems. I doubt a...

You have not offeneded me. I just wanted to clarify the intent of my first post. I see your frustration. The second when section will not get...

I am not disputing the fact that this looks like a bug, I was simply showing you a way to get around the bug and make your case statement work.

Robert...

I don't know if this will help you or not since the economy has changed since I got hired at my current company.

I was hired May 2000. At that...

I don't know why you get the divide by zero error since the ELSE shouldn't get considered. However here is a possible solution:

SELECT

CASE

WHEN @TotalAmt = 0 THEN...

Schedule the DTS package to run. Then go to the job that was created and open the one step you will find in there. Copy the line in...

Here is a VBScript that could work for you. If not, then I hope it will at least get you started. I only know a little VBScript and...

As far as I know there is no quick way to change the connections in a DTS package. This will be a manual process.

I don't know, but think that...

I use a combination of making all keywords upper case along with some indenting and having separate lines for the SELECT clause, the FROM clause, the WHERE clause, etc.

When I...

A thought provoking article. I think a mix of using windows authentication and SQL logins works best. Dependence on one or the other is limited to need. ...

Thanks! I read the article and must say I was hoping it would be simpler than that. It would take me time to learn what I need to...