At my work place i simply RD my PC which is kept online like a server 24X7.I connect to my office PC

from my home PC via VPN. The advantages are...

Years ago i had faced a similar issue where the check db took a lot of time to complete.The issue was later found to be with the disk system and...

Hello,

I have read that a SQL agent startup account should not be a admin on the server as a best practice it is not mentioned why or how vulnerable a...

Hi,

I have got 2 physical machines...

a standard dbcc dbreindex statement would do the same on the particilau table.Infact any index on the table is rebuilt it causes the cpu to dive and come back...

Guys i forgot to mention a important thing...the CPU shoots back at 100% after the rebuiliding completes and i am only rebuilding the clustered index.

thanks

I have a doubt regarding the performance part of database snapshots.Now it's said that one can use a database snapshot as a reporing database where the reports can point to...

check the transaction log shipping monitor, find out the last applied transaction log,find out all the log backups created by the transaction log backup on the primary server after the...

Thanks for the link but it explains using ado.net, is there a way i can insert data using the managment studio.

I really do not use ado.net

thanks for your time

Can someone please explain how i can add a bob object like a word document etc in the sql server 2008 db.

I am not able to understand how exactly a...

yes i was able to install using the x86 option in the options section.Thanks to all of you guys for your replies.

hello,

We are cuurently having a sql 2005 ent edition on out prod servers and are planning to upgrade to sql 2008 STD edition.I understand that you need a ent edtion...

Hello guys,

would like to know if i use a sql (2005) evaluation version to install just the client components(workstation components etc) would that also expire within the evalution period...

I want to deny insert/update/delete permissions to a user who has been given grant execute permission in a 2005 db.

I only want the user to be able ...

Below link helped to solve the problem.

http://vettekerry.wordpress.com/2009/05/04/unable-to-load-client-print-control-in-reporting-services-2005/

deleted the [-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{FA91DF8D-53AB-455D-AB20-F2F023E498D3}] key from registry.

on client pc and it asked for a install pop up ,after installing...