This is a game of whose imagination is more flexible.

More advice:

1. Check with your call logging system vendor's support. For example, we use SQL Server authentication with a call logging...

I found it:

Change Owner in Database Maintenance Plan:

Change Owner in Database Maintenance Plan When connected in Management Studio as SA simply rename the Maintenance Plan. This changes the owner to...

I think that they must have meant Creator not the Owner. In Visual Studio it is Creator, not Owner. And as with the Creator, it should not be changing?

I think...

It can be changed in Visual Studio. Open some Project. Click Project ->Add Existent Package, specify the server. Select a path under Package Path as SSIS->Maintenance Plans. Use the button...

Please see my today's reply to homebrew01 at

http://www.sqlservercentral.com/Forums/Topic406836-146-1.aspx

Hi,

In the case SMTP mail is sent but is not received, I normally ask a person who is responsible for our SMTP server to check SMTP server logs. There...

Could have thought about that myself.

Thanks Gail and Steve!

I selected -P and it said that I was wrong.

But I was right and I tested it. see below.

Yes, -z could be used too, but -P is working for...

If you have a connection pool set by your provider - web server or ODBC source the connection will be there after Connection.Close statement.

For example, go to Start->Administrative Tools->Data Sources...

Very Nice!

I will forward this to our Lead DBA who was (translation-upset) Friday when the vendor blamed the DB performance and it was a front-end issue so...

Let them create views in another database that reference your reporting database. Give people  read-only access.

Happy Birthday, Steve.

Mine is coming in a couple of days and I can not celebrate it now big due to some family circumstances and we did not celebrate my father's 75 due to...

You have to install SQL Server Client on Windows 98. I know I had to install clients on NT4 computers. We normally don't have to install OLEDB and oDBC clients...

Hi Ron,

1 Please, go to Configuration Manager on DATA1 and check TCP/IP ports for all your instances in SQL Server 2005 Network Configuration -> TCP/IP Properties -> IP Address tab. Also...

Janet,

Thanks for posting your code. Good job and well commented!