I think the one thing missing in this discussion is that although when used for the correct purposes CLR integration will prove addition to sql server it still falls foul...

No your not missing anything I'm in the UK and keep having problems with VS deciding to go all US on me for no reason.

Just assumed you might have had...

sp_resetstatus database_name

this should reset the status of the database and allow you to delete it

hth

Dave

I have had this problem as well I find if I explicity cast the datetime parameter into the format I wnat i.e. not US tehn it alwasy works fine.

I don't...

The database will show a still loading in EM beacuse the SQL Server was unable to complete the restore operation due to the alck of space.

If first ensure that you...

I also have this problem and it is solved on my test server which has sp2 so the answer is to apply sp2.

If you've just set up sql mail then I had the same problem some time ago. Basically you just have to restatrt the sql server agent once you've set up...

The reason he/she is doing this because they are equating the performance gains that they can get by splitting the table and indexes onto different tablespaces in db2 to filegroups...

If it is parameter sniffing then there is another very useful article on this by Ken Henderson at

http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspx

hth

Dave

I saw a good solution to this problem on Ken henderson blog

http://blogs.msdn.com/khen1234/default.aspx

which suggest a way of ensuring the correct plan is kept and avoids having to run it every minute.

regards

David...

There is actually two scripts one dictionaires and one for stored procedures.

hth

David

Did you run the sql script that comes with the reports this adds a lot of extra objects into the repository database for use with the reports?

I'm not actually writing scripts for deployment but so that I can extract management information from the servers and display them as reports.

One of the most popular examples is...

I thought i would reply to my own request since I have solved it.

Its dead easy just write a few windows scripts get them to put the info into the...

Better late than never eh!

I just had a similar issue.

Although from the documentation I didn't think I would need to configure the unattended execution account as soon as I did...