Viewing 15 posts - 5,611 through 5,625 (of 6,676 total)
Lowell (2/21/2009)
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
February 21, 2009 at 5:55 pm
Dirk Hondong (2/21/2009)
It is not possible for me to just set a use @dbname inside the proc. The use...
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
February 21, 2009 at 9:17 am
Lowell (2/21/2009)
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
February 21, 2009 at 9:14 am
Lynn Pettis (2/20/2009)
Not using BACKUP and RESTORE. You'd have to export the data to files and then import those files.
Nah - that's too much work. You'd have to...
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
February 20, 2009 at 6:01 pm
Yes - there are probably several scripts already available on this site that do what you want.
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
February 20, 2009 at 1:51 pm
When you run this as a script - it will run in the context of the database you are using. When you create it as a stored procedure, it...
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
February 20, 2009 at 1:35 pm
Seggerman (2/19/2009)
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
February 19, 2009 at 2:59 pm
I would recommend using Redgate's SQL Data Compare instead of writing your own. But, if you don't want to go that route:
1) Create a linked server from one system...
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
February 16, 2009 at 11:33 am
DECLARE @seconds int;
SET @seconds = 14400;
SELECT DATEADD(second, @seconds, '20090101')
,CONVERT(char(5), DATEADD(second, @seconds, '20090101'), 108);
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
February 13, 2009 at 12:38 pm
Ahhh, yes - should have been clearer and stated that it shows up under logins. If you script the login, you will see the difference.
For windows users it will...
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
February 12, 2009 at 3:12 pm
Yes - that is correct, if you count the private addresses needed for the cluster heartbeat connection. Forgot about those 🙂
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
February 12, 2009 at 2:08 pm
If you look at the properties of each one of those users, you will see that the user with the instance\username is a windows user and those users without 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
February 12, 2009 at 2:06 pm
At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.
One for each node
One for the virtual cluster name
One for the virtual...
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
February 12, 2009 at 1:53 pm
If you do run into a performance issue using the structure:
WHERE (column = @parm OR @parm IS NULL)
You can either move directly to Dynamic SQL, or you can try using...
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
February 12, 2009 at 1:28 pm
andrewd.smith (2/11/2009)
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
February 11, 2009 at 3:18 pm
Viewing 15 posts - 5,611 through 5,625 (of 6,676 total)