It looks like EMPTYFILE argument of DBCC SHRINKFILE will help me. But I still need to figure out how?

Bottomline ... I have move the log file(s) of tempdb to a...

Nevermind. I got it.

I am now using sp_helpuser, so that I can get both database user and login.

After that I can use isntgroup column in sysusers table to find which...

I am using sp_helprolemember 'db_owner'  to get the list of DBO role members in a given database.

Some of these members in DBO role are Domain groups or local groups. How...

Hi

We had to implement this just couple of months back because of SOX. As per SOX requirement we had to take away sysadmin rights from many users.

But some of...

Try this out and you will get the what you want:

CREATE TABLE [dbo].[City] (

 [CityID] [int] IDENTITY (1, 1) PRIMARY KEY,

 [CityName] [varchar] (50),

 [TitleID] [int] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Title]...

Securing objects has to be done through maintaining proper previliges on the objects.

We can secure a server in multiple ways and keep the objects inaccessible to unauthorized people.

But when the...

Its hard to find what's wrong with the query, without seeing the query

But I have tried to narrow it down with my best...