Right in 2005; when someone logs in to SQL Server using SSMS it queries the database catalog table so it can view. For testing I created a new login...

If it isn't jobs or someone idea of a really bad joke. The account accessing the database does it have DBO permissions? Is your website SQL Injection proof?

Mohit.

Have a read at ..

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

Gives you basics..

Have a read at ..

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

for Encryption Overview.

Thanks.

Please don't cross post, reply in link also.

It be a bug ...

Look at http://sqllearnings.blogspot.com/search/label/Maintenance%20Plans

Someone else encountered similar issues after renaming 2005 server; so they had to do those steps and start over.

Thanks.

David Barnette (3/17/2009)

---

We were being required to upgrade ASAP due to them not supporting SQL 2000 anymore. We were trying to wait until SQL 2008 was being supported. From...

Aye those books and practice are worth money :).

Thats how I gots my MCTS and MCITP :). Is good to buy books anyhows ..

<-- Book nerd, SQL books...

Rog Saber (3/17/2009)

---

We have a client who is complaining about really slow response time during a process. There is a table that is updated during the process that takes 45...

dallas13 (3/17/2009)

---

I have questions about central management server

According to Books Online Versions of SQL Server that are earlier than SQL Server 2008 cannot be designated as a Central Management Server....

I believe the answer is yes for all of them. I have installed SSRS on computer other then SQL Server, actually that is the best recommend practice too.

Mohit.

I ran into this issue on my cluster also ... have a read ..

http://sqllearnings.blogspot.com/search/label/Clustering

It is an issue with the MSI installer and how the Cluster works in 64x bit...

Please look into proxy accounts for SQL Servers.

http://www.databasejournal.com/features/mssql/article.php/3789881/Proxy-Accounts-in-SQL-Server.htm

Mohit.

SQL Reddy is correct; I created a new user with only connect rights to SQL Server it was able to run @@Version successfully.

Thanks.

You can try using SQLNexus to check out the logs and such. It is a newer version that helps to read trace data collected.

As for Read80Trace, what you can...

Add a where clause like..

WHERE (CMA_projects.news_data_0_system.News_EditedDate + 3) < Convert(varchar(8),GetDate(),112)

I think that should be enough for you...

Mohit.