Thanks Orlando Colamatteo.....first option worked for me...

All,

FYI...

I got my query solved. We can use DB_NAME() function.

Thanks..:)

Thanks Steven for your reply.

We could resolve the issue by restoring back SSRS encryption key and than starting SSRS service.

Hi John,

Request you to tel me the SSIS package steps to run my query against multiple servers.

I would build the SQL query to collect the column information.

After configuring SQL server service account with 'lock pages in memory' permission you have to restart SQL server service.

Than try to restart the SQL agent service it...

Hi All,

Thanks for your replies.

I have used below script

SELECT *

FROM msdb.[dbo].[sysmail_allitems]

And also asked user to share with me the email notification they received.

I could solve the problem.

Hi Durai,

Thanks for your replies. We have identified there is issue with the existing hardware that causes lot of IO.

We have moved the DB to a different server. Now the...

Hi Durai,

Below are some more info

DB size is small around 14GB

Max SQL server memory set to 26000 MB and Total Physical memory of the server is 30 GB

Minimum memory...

Customer would fire insert,update,select queries most of the time. Most of the tables have clustered index and some of them have combination of (clustered)+ (non-unique,non-clustered indexes).

Statistics are up to...

Hi,

I would suggest you first to get the details of the task user wants to perform against any DBs in SQL server. These would help you to identify what server...

1. I need to shrink my database file. what is the maximum size of database file(i.e mdf).my mdf file size is 978 mb.so can i shrink my database file?.Plz give...

1) Lets assume that you are targeting the user database name TargetDB

2) Open the SQl server management studio

3) Click on the + symbol on the left hand side of the...

Hi,

I would like to share one more way to copy huge size files from one server to another without files getting corrupted.Please download the robocopy.zip from the below URL

Hi,

Shrinking of database is different fron shrinking the .mdf files.

I won't recomend you to go ahead with the shrinking process using SQL server management studio as the size of the...