Need some more information about the error your getting to be able to assist. But check this link for information on using it...

http://msdn.microsoft.com/en-us/library/ms141773(SQL.90).aspx

Agreed... the only real options are WITH ENCRYPTION and third party tools. Your other option... although it has a host of other issues is to use CLR/.NET stored procedures...

Cool. I think that the issue is essentially SQL uses the the machines windows server name env. variable to connect for the "locahost" instance. So it try's to...

Maybe you can do something with a CTE like the following...

DECLARE @Tbl AS TABLE (

Symbol INT,

MarketDate DATETIME,

Price DECIMAL(10,2),

Volume INT

)

INSERT INTO @Tbl

VALUES (1, '1/1/2008', 1.00, 100000)

INSERT INTO @Tbl

VALUES (1, '1/2/2008',...

Change the connection from localhost to the actual SQL Server Virtual Name.

There is a change computer link next to the text "Configure Surface Area for localhost"

If the same queries being excuted quickly are on the same production server then likely the issue is with the application versus the database. I would look at the...

I guess it depends on your definition of no down time. Based on how you are talking I assume you mean minimal time. What is the size of...

There is no magic set or magic numbers on the counters. You will find all kinds of different articles about what values are valid. The real way is...

As another idea... if you want to be careful for support going forward you can script out the code in the undocumented stored procedure and then re-write your own procedure...

I assume you are running sp2?

Also quick search I found an msdn forum post about integration services error with the same message. Maintenance plans are built in SSIS now,...

There are several possible reasons for that condition.

1. The size of the database when first created had an initial size set to the 36gb. So it is just filling...

The having clause is evaluated after the group by clause. A group by is required to use a having. It is unassociated with the select portion of the...

Not sure if there is a better way, but you can create a linked server pointing back to the original server (like a loopback). Then you can use the...

Use sp_send_dbmail. You can specify a query parameter to be attached as a file. You can also specify a header and a delimiter. So setup a query and...

Check the variable size. Might be a truncation issue because the db name is so long.