Viewing 15 posts - 181 through 195 (of 287 total)
By default SQL Server 2005 will generate a 512 bit certificate for this purpose. You will of course need to distribute the certificate to the clients.
You can, however configure...
February 15, 2006 at 5:41 am
No, you can't do this.
If you understand first that the OS must be clustered, *then* you install SQL Server, the answer is self evident.
You will need two machines clustered for...
February 15, 2006 at 5:30 am
Check you meet the rules on upgrading replicated databases:
# If you use SQL Server 2000, service pack 3 (SP3) or greater is required.
# A Distributor can be any version as...
February 15, 2006 at 5:24 am
If 1433 isn't blocked, then the firewall is unlikely to be implementing the drop all/any default rule, so the box'll be rooted through other means.
Can I ask; what is out...
February 15, 2006 at 5:03 am
You really don't want to enable SQL authentication anyway or use the sa account - grant a windows group access and add your windows account to it.
February 15, 2006 at 4:58 am
Default installation is windows only authentication *thank Bill*
February 14, 2006 at 8:55 am
Search results for: 211.233.38.77
OrgName: Asia Pacific Network Information Centre
OrgID: APNIC
...
February 14, 2006 at 8:42 am
As Neil said - grant users the permissions to do their jobs, not sysadmin memberhips.
However, you can prevent casual database deletions with a trigger:
CREATE TRIGGER STOP_DB_DROP
ON ALL SERVER
FOR DROP_DATABASE
AS
PRINT...
February 14, 2006 at 8:32 am
Doh. I switched to Vue for these exams after 7 years with Thompson...typical.
Anyone seen an increased demand for 2005 skills? THe job boards seem to just have 2005...
February 14, 2006 at 8:22 am
The answer is in the question - you can't cluster SQL server without clustering the operating system.
Can you cluster Windows 2003 standard edition? No.
Hope this helps.
February 13, 2006 at 7:17 am
*= was a Transact-SQL shorthand, not an ANSI standard.
February 13, 2006 at 7:07 am
Passed 70-431.
My profile was updated today, the dates shown are the date I took the exam, and MCTS was awarded 25th January...
February 13, 2006 at 6:48 am
This is a SQL 2005 forum.
I believe SQL 2000 64-bit edition only runs on Intel Itanium and Itanium II chips.
February 10, 2006 at 3:12 am
Andrea,
It's probably just a parameter you've missed out. Users can run sp_password on their *own* account, but they must specify the old password.
--Try this logged in as user1
--This will...
February 10, 2006 at 3:01 am
The asymmetric keys are stored in sys.asymmetric_keys, just restore from there.
February 10, 2006 at 2:34 am
Viewing 15 posts - 181 through 195 (of 287 total)