Mirroring is an inexpensive H\A and DR solution. Is has beed designed for that and developed for that.

Not for reporting purpose, you must have a report server if you need...

Thanks!

DBCC CheckDB

Well it's always best to create your own custom report that suites your needs,

After all you are the custodian of any loopholes that may arise in the sql environment.

Is it always necessary to rebuild indexes or once can just do DBCC and Backup and recovery only?

What tool or script can i use to detect whether tables need reindexing?

With...

Hi,

have you also tried installing SQL using slipstream command?

Has anyone has a solution to this question as i also need some tutorials on Policy based management on sql 2008.

please guys.

Hi, I have similar problem, i have Disk1 for inst1, disk2 for inst2, and disk3 for inst3 but i cant have other instances running on the same SQL networkname.

pls help,

i would assume this simply means you can upgrade from RTM version straight to SP4 with prior to SP2 or SP3 installation.

SQL Instances run as windows services.

so what you must do is deleted the services as follows:-

ON THE COMMAND PROMPT RUN THESE COMMANDS.

sc delete MSSQLSERVER

run sc delete commdand for all SQL...

Have you tried sp_help_job stored procedure?

Hi, I don't know if this helps but FYI i had a look at the Table properties of all the tables that are involved in this query and here are...

Eddie is right, what i am experiencing lokks exactly like wha Eddie has said, "Session deadlocking themselves"

The reason i say so is because the SPID that gets thrown by SQL...

I think that's a good idea, i will do that and show you the results.

Yes but im still waiting for my Manager to approve.