Viewing 15 posts - 8,041 through 8,055 (of 9,244 total)
emily-1119612 (4/21/2010)
I gave up on xp_delete_file.
it does work extremely well if you take the time to get to grips with its parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2010 at 6:01 am
karthik -450760 (4/21/2010)
I tried to login to the server through Remote desktop connection and I got the error message ,
" The account is configured to prevent you from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2010 at 5:58 am
CirquedeSQLeil (4/21/2010)
But can the OP logon to the same server that is having the problems with that user account?
is why I suggested login to server if account or domain is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 3:08 pm
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
Viewing 15 posts - 8,041 through 8,055 (of 9,244 total)