Hi,

As Gail has suggested, please post your execution plan.

At first glance it would seem that your query could benifit from additional indexes being added to the tables involved in your...

No problemo Carl.

So if you execute the following script is the DAC endpoint specified to listen on a specific port?

select * from sys.tcp_endpoints

If the value is set to 0 then...

You may also find the following article useful on identifying the ports that your SQL Server Endpoints are using and also the rules that are used for each.

http://blogs.msdn.com/sql_protocols/archive/2008/11/05/tcp-listening-ports-and-endpoint-ports-behavior.aspx

Hi Carl,

So you are attempting to use the DAC locally to SQL Server then?

You see the DAC will only permit local connections by default and so network connections are not...

Have you checked that the DAC is enabled on the SQL Server Configuration Manager?

Rather than creatining an additional transaction log backup, you should modify your log shipping configuration by increasing the frequency of the log backup job.

Hi Christina,

If I may answer on Adams behalf, it sounds as though you are attempting to open BIDS rather than a specific version of visual studio.

The Express version of Vidual...

Hi,

Typically the way to do this is to disable or alter the maintenance plan. The configuration process for log shipping will create and define a transaction log backup job (certainly...

Out if interest is your environment a clustered server configuration?

Hi,

I think you may be able to use the DMV sys.dm_exec_connections to get the information you require.

For example the following code will get the IP address of the current connection.

SELECT...

You're most welcome.

I would be interested to know how you get on and no doubt so too would others. If it's not too much trouble keep us posted.

Cheers,

If you wish to obscure data from a DBA then I would suggest using a CLR procedure to manage the encryption/decryption rather than a stored procedure implementation.

Provided the DBA does...

Yes, this also applies to log files.

The point to understand here is that the proportional fill only applies to files within the same Filegroup.

You may find the following reference useful...

Hi there,

Well, as I am sure you know there a numerous SQL Server technologies that provide availability solutions.

Which one you choose will depend on the requirements of your specific business...

All SSIS Tasks have basic instruction on their usage within SQL Server Books Online. Link included below for reference.

http://technet.microsoft.com/en-us/library/ms142165(SQL.90).aspx

Using a Send Mail Task is quite straighforward, you just need to...