Hi,

You have to set Recovery Model in database properties Option tab to Simple or Bulk-logged for the time of package execution depending on what your package is doing. Please note...

Scott,

do I understand correctly that you would like to "either drop or add a specific user (which will be the DBO)" I mean, you would like to change a...

Hi,

I do have cases when users call and tell us they don't see the data they think should be there. It is mostly a report parameter issue or report code...

Hi SQLBill,

not the "Not So"  but "Yes so" I say:

<quote>If you can ping by IP but can not connect to SQL Server by IP it is still Firewall issue<end quote>

I...

Hi Jamie,

actually found your site at

http://blogs.conchango.com/jamiethomson/archive/2005/02/11/993.aspx

as a first one when searching Yahoo for "data flow asynchronous SQL Server 2005 - SSIS" I saw your explanations received from the member...

Rudy,

TCP 1433 is a default port for a default instance, a DBA can easily change that in Server Network Utility. Additional Instances including MSDE will install on different ports.

See if this can help you

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=9576

Hi,

For just auditing SQL Server logins you may use Profiler Server Trace,  I used it, for events:

-- 14 Login

-- 15 Logout

-- 20 Login Failed

For alerts you may use Windows...

Hi,

Ask them network admins to open port 1433 and 1434 (the later one is helpful for instances)

But the very first thing that I will do is to use Fully Qualified...

Oops.

That is how I read it "Transaction log backup.....15 min......." So I got it that it is every 15 min, not once each hour at 15 min after the...

Danny,

For SFTP:

If it is Windows servers then you may use Tectia on the receiving server end and PuTTY client on the sending end. I know that they also use SSH...

Ravi,

There is more reasons to use Profiler in this case if you say that only Named Pipes connection does not work! You will pinpoint the exact line where it does...

Hello,

Please, see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT19.asp

If it does not help then call VeriSign and visit their website for help on certificates. I had problems generating and installing SSL Certificate for WebLogic and I chatted...

SFTP will do it.

Yelena

I would run the Profiler with TSQL  SQL:StmtStarting which is designed to capture events that are not completing properly. I would capture Text data from both running a query from...