Grasshopper, once I create my SQL 2000 Maint Plan (for Txn Log Bkups to run every 30 min's 5am-5pm) How do I view the SQL script as you suggest?

(I too...

thanks Grasshopper -- I modified your code to look like this:

DECLARE@CheckDate DATETIME, @DayOfWeek SMALLINT

SELECT @CheckDate = '2008-07-06 00:00:00.000'

SELECT @DayOfWeek = (SELECT datepart(weekday, @CheckDate))

SELECT @DayOfWeek As TheDay

-- 1=Sunday

hmmm -- isn't your repsonse analagous to something like this:

Do you have a recipe for a chocolate cake?

Yes, mix ingrediants and cook it. hahahaha (need specifics and preferrably...

well that was simple -- just ran the Office 2003 Setup.exe and the first thing it does is to prompt Add/Remove Features -- I checked Access and it installed just...

Yes. Also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37335

Nigel - thanks - that worked great. 1 more question ----

Is it possible to test the cell value for multiple values -- and depending on the value, set the...

Hari.Sharma -- Exactly what I was looking for -- worked great. Thanks!

To list my output in vertical format, I created 1 dataset and manually added 8 text boxes (1 label; 1 data element) for each of the 4 elements in the...

Gents - thx a million. I've forwarded this "active" discussion to my counterpart DBA and a developer. (I'm leaving for vacation - be back Friday). Both of your...

Thx for the reply. As mentioned, the only error I get is the displayed msg: "#Error" in the text box. AND, this report executes perfectly in mgmt studio....

VS 2005 8.0.50727.762

VB 2005 77626-009-00000007-41529

We also added two references (on the Report Properties screen) System.Data and System.Data.SqlClient

We have over 250 SQL 2000 DTS packages. When we migrated ALL of our prod SQL 2000 Servers to SQL 2005 64-bit, we opted to leave 1 behind and...

Got it:

USE myDatabase

GO

IF EXISTS (SELECT Name FROM sys.sysusers WHERE Name = 'myDomain\BOB ')

DROP User [myDomain\BOB ]

GO

CREATE USER [myDomain\BOB ] FOR LOGIN [myDomain\BOB ]

GRANT EXECUTE ON...

OK - but I cannot delete from system catalogs. This T-SQL:

USE myDatabase

GO

IF EXISTS (SELECT Name FROM sys.sysusers WHERE Name = 'myDomain\BOB')

DELETE FROM...

It's been a while but I will tell you that if you plan on installing SQL 2005 Management Studio on the same desktop w/ SQL Server 2000 Enterprise Manager, BE...