Viewing 15 posts - 8,041 through 8,055 (of 9,241 total)
My reply says logon to the server not SQL server 😉
the best way to check an accounts validity is to logon to the server, true it doesn't have to be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 2:54 pm
firstly logon to the server with the account details and verify success.
Next, change the service account info and enter the new password via SQL Server configuration manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 11:28 am
Subversion is a great source control product, highly recommend it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 11:26 am
Couldnt agree more! Litespeed or SQLBackup are both great products.
Redgate offer generous discounts too which make the product affordable and it has great features. I use it and recommend it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 11:24 am
if you only want a 2 node cluster Std edition should suffice. You will lose a few other features but its still an option
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 11:18 am
to further my point and using Pauls kind example
the following would fail and hence, would only allow a single NULL value
USE tempdb;
GO
CREATE TABLE dbo.Parent
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 9:33 am
sorry my bad that is only for SQL 2005 onwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 12:42 pm
just out of interest what version SQL server are we talking here?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 12:37 pm
WayneS (4/20/2010)
Perry Whittle (4/17/2010)
when referring to key constraintsPrimary key does not allow NULLs
Unique key allows a single NULL value
so the 2 are different in that respect
I was just thinking about...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 10:44 am
mate, your keen this thread is over a year and a half old 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 8:14 am
are you seeing this on all databases that are having indexes rebuilt??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 4:27 am
run this on each server and it will create an alter login script with the old password
select 'alter login [sa] with password = ' +
sys.fn_varbintohexstr(password_hash) +
' hashed' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 3:32 am
create index and alter index rebuild are both minimally logged.
What is it leads you to believe they're not?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 3:02 am
hi
can you post a screenshot of the server logins from management studio
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 2:21 am
Jeffrey Williams-493691 (4/19/2010)
there are times when using a local account is the right thing to do.
in my opinion only when using a windows workgroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 2:02 am
Viewing 15 posts - 8,041 through 8,055 (of 9,241 total)