Viewing 15 posts - 5,506 through 5,520 (of 9,244 total)
Jeffrey
the user requires the clear text password for the SQL server account so sp_help_revlogin wont be helpful here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 11:13 am
Abhilash T (6/3/2012)
yes Right,Bu I couldn't change it. Bcz its live and lot of developments done with this.
hmm, seems a bit daft to me to be honest. What if someone...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 11:11 am
Abhilash T (6/3/2012)
Hi All,I have a table with lots columns(all columns not included here).
ISSUNDAY BIT,
ISMONDAY BIT,
ISTUESDAY BIT,
ISWEDNESDAY BIT,
ISTHURSDAY BIT,
ISFRIDAY BIT,
ISSATURDAY BIT)
Why not just have one column for the weekdays...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:30 am
Develop locally and use package variables, you can then update the connections when deploying to live
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:21 am
I had a discussion with another user regarding AO and fail over clusters, you can follow the topic at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:17 am
Bobby Glover (6/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:07 am
dan-572483 (6/2/2012)
Is this because SSMS 2008 can connect to an R2 instance?
No you should be able to connect but certain features won't work when trying to use them possibly.
dan-572483...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 4:02 am
Bobby Glover (6/3/2012)
Probably a easy one,I've inherited a new SQL 2008 Enterprise environment which uses encrypted databases.
I don't have the passwords for the certificate.
Your statement implies that the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 3:25 am
If the web.config is encrypted or, if it's a windows form app, it encrypts the details in a registry key then it should be fairly safe.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:25 pm
Shark Energy (6/1/2012)
Cache could be an issue. Previously this server had its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:53 am
Remember that your offset is ultimately dependent upon your RAID stripe size, you probably shouldn't just accept the windows default. There are a whole bunch of calculations to make including...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2012 at 1:51 am
opc.three (6/1/2012)
IIRC Server 2008 uses an offset of 1024KB as a default when provisioning a new disk
Yes it does it's a sort of one size fits all, default configuration.
opc.three (6/1/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:47 pm
Shark Energy (6/1/2012)
Good questions - I have that all written down for the old server but not for the new one.
Investigate thoroughly and compare them to see the differences.
Shark Energy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:20 pm
Why can't you just change the password and update the app connection?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 6:06 pm
number of disks?
cache size?
RAID stripe size?
Storage paths?
There are so many factors that can have an effect.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 2:37 pm
Viewing 15 posts - 5,506 through 5,520 (of 9,244 total)