ganeshmuthuvelu (7/16/2008)

---

Hello,

I have a Schema by name "Common" in which I want a set of users "user1, user2, user3" to have full control on it. That means they can create,...

The following command grants access to ALL stored procedures in...

To create a role:

Use database;

Create Role rolename Authorization owner;

Grant execute rights to the stored procedures:

Grant Execute On Schema::schema To rolename;

If all of your stored procedures are in the dbo schema,...

Here are a few examples:

SELECT dateadd(month, datediff(month, 0, getdate()), 0)

,dateadd(month, datediff(month, -1, getdate()), -1)

,dateadd(month, datediff(month, 0, getdate()) - 1, 0)

,dateadd(month, datediff(month, -1, getdate()) - 1, -1)

,dateadd(month, datediff(month, 0,...

Try: Select * From ::fn_trace_getinfo(default);

Try the following from the new database.

Execute sp_change_users_login 'Report';

If this returns any data, fix the user accounts that are reported.

You don't need SSIS installed, but you do need the client tools. If you have...

No problem 🙂

Peter Lavelle (7/15/2008)

---

Jeffrey,

Thanks for your point about ;

Yes you are right of course.

I am using SQL 2005 and could not get WITH to work until I realised it needed...

Well, sort of. Each vendor implements the ANSI standards to a particular level - and each...

If I had to guess, I would guess MySQL. The syntax may be similar - but, not knowing MySQL I would not bet on what works for T-SQL (Microsoft...

Two options that I know of:

1) Export the maintenance plan to a file, create a new SSIS project in BIDS - add the maintenance plan to the project, modify...

balbirsinghsodhi (7/15/2008)

---

Steve.. Thanks a lot.

I like your idea of denying connection to sql server. Here is the TSQL I am going to use. I will deny connection for all the...

From BOL under the ALTER LOGIN help:

You cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group. For example, ALTER_LOGIN [domain\group] DISABLE will return the following...

SQL King (7/15/2008)

---

Well, this question regarding Reindex has struck something important for to reconsider about my databases. I am taking a fullbackup no matter what. I do have full recovery...