I tried the below statement and it is working fine:

Declare @Tbl table (uname varchar(50), type varchar(10), privlege varchar(10), lname varchar(50), path varchar(10))

Insert into @Tbl exec master..xp_logininfo

Select * from @Tbl

You can use Job Scheduler of SQL Server to schedule your task at 12:00.

I do not think that using EXCEPT keyword will fulfill the requirement. As it will give you all the records from table1 which are not present in table2.

But what...

I also use Redgate SQL Compare and its a great tool.

To delete records in small batches like say 100, you can set ROWCOUNT to 100:

SET ROWCOUNT 100

Delete from TableName

The above statements will delete only 100 records from the table;

If you want to do insert, update and delete in one target table on the basis of joining results with other table then you can use MERGE operator of SQL...

Still waiting........

Thanks.

But Server Role sysadmin allows login to do anything on the server. I just want that login can access all the databases.

I have DONE that using this piece of code:

SET QUOTED_IDENTIFIER OFF

GO

alter procedure GetFileGroupDetails

AS

BEGIN

SET NOCOUNT ON

DECLARE @iRowCount INT, @iCount INT = 1

DECLARE @sSQL NVARCHAR(255), @sQuery NVARCHAR(500)

DECLARE @sDatabaseName SYSNAME

DECLARE @tblDatabaseName TABLE (Id...

Also gives detail of particular database

Thanks for your reply.

But it gives you the details of a particular database.

What I want is to know the filegroup details of all details in a server.

Master database contains all the system-level information for a SQL Server system.