Hi,

It is not required.

Regards

Shafat Husain

Hi,

Add a "Set NoCount on" in the beginning of the proc or script you are running and check again.

Hope it helps...!!

Regards

Shafat Husain

Hi,

I am sure you must have already checked these things but still to re-iterate.

1. Check the protocols under configuration manager.

2. Check if you are able to ping the Server from...

Hi,

Could you please share what are you doing in this SSIS package?

Regards

Shafat Husain

Dear Joy,

Triggers always have a performance impact as they will keep you transaction open till their execution is completed. It does not matter whether it is DDL or DML trigger.

However...

PS

5.5 DBCC UPDATEUSAGE(db_name); (To Fix page count inaccuracies)

Hi,

1. Take Backup of all the user and system databases.

2. Run SQL Server 2012 Upgrade Advisor and check for any warning or error.

3. Check BOL for "Breaking Changes" and "Behavioral...

Hi,

Steps for adding a secondary data file using GUI:

1. Right Click on the database -- > Properties

2. Click on Files

3. In the right hand pane click on add and provide...

Hi,

Did you use a shared datasource or an embedded datasource?

If it is not the latter one then probably you should try with embedded then.

PS: Very less experience on SSRS, Just...

Dear Alex,

As far as i know with my limited experience with SQL Server i have not seen a scenario where in we can send the query/SP in the email...

Dear Avdhut,

Although this is not a SQL Related question.

but here you go.

In the excel sheet right click on the cell on go to "Format Cells" and select "Text" and click...

Dear Arooj,

Could you please provide a little more information. as in

1. How did you move db instance from one server to another.

2. Are you able to access the report...

Dear Shreekant,

SQL Server has following 3 types of backup:

1.Full backup

2.Differential backup

3.Transaction log backup

Full backup takes backup of complete data and log file upto that time.

Differential backup takes backup of all...

Dear Shankar,

There is no harm in installing SQL Server in D Drive, Just Make sure you have regular disk backups for D Drive so that same can be used in...

Not Sure about a permanent fix however restarting SSMS solves the issue temporally. 🙂