Dear Manju,

Merge Replication use a lots of metadata and tracking tables to store the information about the replicated tables.

Over a period of time a lot of data can accumulate in...

It will work provided you are able to access the databases stored in that folder.

Also i would first try and give Read/Write Permission on the Existing folder where you have...

Dear Santosh,

As the error suggest you have to give read/Write permission to the SQL on the Folder havnig ndf file. Alternatively you can try and move the ndf file to...

Hi,

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

On the Security page, under Server authentication, select the new server authentication mode, and then click OK.

In...

Dear Dexter,

I am having a funny feeling that probably something is wrong with login that you are using to create the linked server. I would suggest that you try to...

Dear Lakshmi,

In the server name textbox write "localhost" or try with a simple "." (Without the double quotes :-)) as the servername and use the existing username and password. Probably...

Dear Ashish,

As the error suggest School_Year is not a part of either a aggregate function or a group by clause.

What you need to do is ad School_Year in the list...

Hi,

Try passing a size parameter with your original query:

alter database tempdb

modify file (name = tempdev, filename = 'D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf', size = 1GB)

go

alter database tempdb

modify file (name = templog,...

I have faced this issue one while trying to open the stored procedures using SSMS. Everytime i tried to expand the stored Procedure node it gave "Lock request time out...

Please share the structure of the appointment table and the format of the desired output.

Regards

Shafat Husain

Try this link. It solved mine issue.

http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

Restore Database [Database Name]

from Disk='[backup location]'

with move '[logical data file name]' to '[path to store mdf file]',

move '[logical log file name]' to '[path to store ldf file]'

to find out the...

Error Code 5 Signifies Access denied. Account which is being used to run SQL Server Agent does not have write permission on the COM folder.

Add Write permission on the COM...

There is no limit on the number of the Global temporary tables you create in sql server.

Memory is limit...!!! 😎

Hi Dave,

Few clarifications:

1. Do you want to move your clustered index only or the primary key as well.

2. I am also getting a feeling that MAYBE you want to change...