Got it - should have known it was something simple like that. Thanks!

We use an ActiveX script task to set a global varible to the system date. Maybe you could set the package name this way too?

Example

'**********************************************************************

' Visual Basic ActiveX...

I've never been asked to read the transaction log, but I'm pretty much a novice at this DBA stuff!

What are some reasons why a DBA would do this, especially...

We use C2 because we are required by the government to do so.

From what I undertand, C2 audits all events.

The events are written to 2000MB rollover files located...

A new error log doesn't seem to have started. How do I check for a SQL symptom dump in the log directory?

Connectivity came back after the restart and hasn't happened...

I have a DTS package that contains lots of Execute SQL Tasks. To pass parameters to these tasks, I go to Package Properties, Global Variables tab, and define variables there....

What would one do if a database started with identity as PK and then years later became larger than expected and ran out of numbers to increment to? How can...

Great suggestion - worked wonderfully

Thanks

I tried your script and it ran great, thanks.

The only thing is....still while the physical file names are correct, the logical file name for the new DB remains the same...

I looked up the command in Books Online and executed it. I backedup DatabaseA and tried to restore as DatabaseB. In EM, the database shows up as DatabaseB but when...

Thanks for the advice and the link - The NT account that runs Agent is a member of the SQL Server sysadmin role and is member of the NT System...

Thanks so much for the responses.

I just found out that simply configuring SQL Server to work on another port won't work either. They are closing everything and allowing by exception....

To my knowledge, no new software has been installed on my workstation or 2 other workstations having this problem. I checked the client network utility and it matches the server....

For QA, I get the dialog box to connect. Then I see a query window where I can type a query. If I hit F5 the query returns records.

But I...

I have gotten this error a couple times in EM while connecting to our remote SQL Server (2000).

I don't remember exactly, but I think I've gotten it while trying to...