Perry Whittle (4/30/2015)

Incorrect, you do not need the DMK from server...

Hi,

Check out

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724832(v=vs.85).aspx

I guess confusion will be for Windows Server 2003 and Win2K3 R2. 🙂

but for others its just a difference of whether server edition or desktop/home OS

Hi Sameer,

Yes, you will have to copy the certificates and keys from both the prod servers to the DEV box.

tempdb will also get encrypted on the DEV. Below are steps...

Hi,

A more simpler

Select @@version or

select * from sys.dm_os_windows_info

will give you the Windows Version name.

You will have to compare the returned value to find the OS name.

For your...

Also the mindset to not own the issue upfront !

I have seen few support teams simply 'soft-denying' to own up the issue or even offer a decent investigation. Due to...

Hi,

You could use powershell as well ?

Not sure what all you want to be sent in the email; but if its something like disk space usage etc, then you can...

Hi Bala,

Try to get an estimation of how and what actually will be the use of the SQL and dbs. Usually its told as to be 'very small', but eventually...

Hi,

You will also like to take a look at and try to draw conclusions after analyzing the stats from the results of various DMVs available.

sys.dm_os_wait_stats and schedulers to identify if...

Hi,

You can goto the job properties and then remove the shared schedule showing under the Schedule tab.

Once the shared schedule is removed you can then create new one as per...

Hi,

See if this helps

a. Find the session id of the dbcc command being run.

b. Use the session id below -

select percent_complete from sys.dm_exec_requests where session_id=xxx

The percent...

Not sure if you would be able to deploy the solutions in the environment immediately or easily -

a. Build a farm for RS

b. keep the RS server seperate from...

Hi,

You will have to take a look at the type of reports running at a time in the queue.

Also custom output rendered reports tend to consume more memory.

Found this article on similar issue ..

Hi,

What is the OS on which you have SQL installed ?

are you able to use all other features/functaionality of SQL Enterprise w/o any problems ? or this is just with...

Hi,

Can you check the installation summary file ?

You can find it probably at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

also check if any error logged for SQL ..