Viewing 15 posts - 5,521 through 5,535 (of 6,583 total)
Lowell (2/21/2009)
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...
February 20, 2009 at 6:01 pm
Yes - there are probably several scripts already available on this site that do what you want.
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...
February 20, 2009 at 1:35 pm
Seggerman (2/19/2009)
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...
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);
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...
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 🙂
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...
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...
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...
February 12, 2009 at 1:28 pm
andrewd.smith (2/11/2009)
February 11, 2009 at 3:18 pm
What you have left to do is not going to be easy. Especially since you have no reliable method of determining that the first element in the space delimited...
February 10, 2009 at 3:56 pm
As written - your trigger is only valid when you can guarantee (for all time) that there will only ever be a single row updated at a time.
If you try...
February 10, 2009 at 3:49 pm
Viewing 15 posts - 5,521 through 5,535 (of 6,583 total)