But if you are facing Error No 15466 & 15185

This link has a solution for you. However i've not tried and tested it.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/36d70593-7abd-4759-91ab-47ee03ce84d0

&

http://www.lazydba.com/sql/1__28582.html

Do tell me which helped you indeed.

If you are facing 64 bit to 32 Bit error

You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to...

Tara (8/28/2009)

---

I a, trying to implement some audit on sql server databases. I dont think there is a way in sql server to identify modified date of a particular database,...

Happy to help you 🙂

As already stated SQL Server gives commulative Service Packs , SSMS is just a Client tool for SQL Server.

This can happen only if you are using SSMS of a different...

You should not use unlicensed version\softwares but if you don't have any license and still you want to learn SQL then you can download the evaluation version for free from...

Danb7183 (8/24/2009)

---

when I attempt to access the properties of SQL server agent jobs they are all blank. I've read through varying sources that a service pack needs to be applied...

See the service packs are commulative for SQL Server as a whole.

Try to run the following commands on your SQL Server and see what comes.

exec sp_server_info

go

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY...

luckysql.kinda (8/24/2009)

---

I also used FORCE while restoring the master key. But in vain. Need help, Mike!!

RESTORE MASTER KEY FROM FILE = 'C:\Documents and Settings\v-ajohri\Database Backup\mk.dat'

DECRYPTION BY PASSWORD = 'Cheeku'

ENCRYPTION BY...

This link will definately help you.

http://support.microsoft.com/kb/827422

I am just a learner. Not a expert, I was just trying to help him.

gmamata7 (8/23/2009)

---

Hi,

I'm installing SQL Server 2005. I have the following drives:

C -OS, D -Data, E -Log, T - Tempdb, Z -Backups. So while installing SQL Server, I have select the...

Chances are You'll get your session back if only VPN connection broke down.

Let's assume that you're working from Home...using VPN to access your office system.....and using your office system client...

Mike C (8/23/2009)

---

Before you do anything further with this database, immediately take a backup and store it somewhere.

Next restore the backup database to a different database and immediately try to...

I never knew that.

Thanks Steve.