Tried it, but not working...

Thanks!

This will deny all connection to SQL server regardless where they are from. I just want to deny the connection from SSMS from remote servers.

I have a snapshot replication to populate latest data to read_only server for reporting. But some user start running reports before replication starts. This cause replication fail with can not...

I got this dynamic query working on query window, but not working in SQL agent now.

Executed as user: US\serviceaccount. Incorrect syntax near 'linkservername'. [SQLSTATE 42000] (Error 102). The step...

I got following error when I tried to run through query window. I am the sysadmin on both servers.

Could not connect to server 'linkservername' because '' is not defined as...

I have tried this. The problem is the user I login with (my domain account) when I use command line does not have right to grant sys_admin right. I...

After dig a little further, I have found there is a partition scheme created and it is pointing to serveral file groups. This table is using this partition scheme.

Here is first two colums came out from folloing command. The first column is the object name and second column is filegroup name

SELECT OBJECT_NAME(object_id), *

FROM sys.data_spaces ds

JOIN sys.allocation_units au ON

ds.data_space_id...

Please forgive me. I am new DBA. So here is my situation. When I right click on database name and go to properties, I see several database files and each...

Sorry I should make this clear at the first place. I have one table that sitting on several file groups. I am trying to consolidate all data into one file...

Thank you!. The first script is really helpful. but I need to move data from one data file to another before delete the data file. I do not lose any...

Thanks!!