Viewing 15 posts - 6,346 through 6,360 (of 6,676 total)
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,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 3:00 pm
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,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 2:42 pm
Try: Select * From ::fn_trace_getinfo(default);
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 2:14 pm
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 2:05 pm
Brian Brown (7/16/2008)
1) We do not have SSIS installed, therefore we cannot export a package.
You don't need SSIS installed, but you do need the client tools. If you have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 1:55 pm
balbirsinghsodhi (7/16/2008)
Sorry about that.Thank you Jeffrey.
No problem 🙂
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 1:48 pm
Peter Lavelle (7/15/2008)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 10:54 pm
Harsha Shettigar (7/15/2008)I'm using Informix database. My understanding is that SQLs wouldn't vary greatly??
Well, sort of. Each vendor implements the ANSI standards to a particular level - and each...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 10:40 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 10:15 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 4:50 pm
balbirsinghsodhi (7/15/2008)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 4:21 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 1:39 pm
SQL King (7/15/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 9:32 am
pardeep (7/14/2008)
Transactional replication will obviously the last or may be mandatory option left.
Anywys, nw plan is something like....
A and B are clustered, seperate machines, active/active.
Db A -->replication to Db B(on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 15, 2008 at 9:22 am
My first question would be why are you using a cursor? Are you sure this cannot be done as a set-based process?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 14, 2008 at 4:20 pm
Viewing 15 posts - 6,346 through 6,360 (of 6,676 total)