Server Configuration

Problem installing SQL Server Express 2008
I went to the MS website and downloaded SQL Server 2008 Express I got a window that says SQL Server 2008 with advanced services did not install succesfully and the downloaded file failed signature verification. The log says: Signature verification failed on downloaded file. URL: http://download.microsoft.com/... 11 Feb 2010 22:58

Handy Free Tools from SQLsoft
Hi All, We've written a number of (I think!) handy (and free) tools over the past few months which are available from here: http://www.sqlsoft.co.uk/ Newly released is SQLscripta, which both searches _and_ scripts sprocs, functions, views and triggers, with searches being performed across multiple databases ... 10 Feb 2010 15:42

O/S when running SQL2005 SP3
Hi, As we know the O/S requirements for SQL versions are defined at the time of the SQL release and may get updated as new O/S's come out. We are running SQL2005 (mostly SP2 currently) on W2K3 servers. If we bring in new servers running W2K8 R2 can we still install SQL2005 SP3 builds on that O/S? I canno... 10 Feb 2010 19:07

Even if check it or not it's the same
SSL disable worked for me... honeybee86 via SQLMonster.com wrote: Hi, Even if check it or not it's the same...I am really stucked... 14-May-08 Hi, Even if check it or not it is the same...I am really stucked... John Bell wrote: -- Message posted via http://www.sqlmonster.com Previous Posts In This ... 10 Feb 2010 10:01

changing schemas
We have 3 different schemas in a database and have created user for each schema with default schema set. However for dbas, is there a easy way to switch current schema which is only for that session. In oracle one can do ALTER SESSION SET CURRENT SCHEMA = 'schema_b' What is the equivalent in SQLServer? thanks ... 11 Feb 2010 10:34

Database Mail
SSL worked for me. But is there any reduced security risk in disabling this? honeybee86 via SQLMonster.com wrote: Hi, Even if check it or not it's the same...I am really stucked... 14-May-08 Hi, Even if check it or not it is the same...I am really stucked... John Bell wrote: -- Message posted via htt... 10 Feb 2010 10:01

how to sync fileds between tables in different database
Hi, I want to provide synchronisatiion between fields of two tables in different databases. what can be acheived by synchronising two fileds. I have databasea db1 and db2. In db1->TableA,db2-->TableB TableA-->EmpID,EmpName TableB-->EmpID,DeptNo. i want to provide synchronisation between EmpID fields in both tab... 10 Feb 2010 06:42

db mirroring disconnected
Hi Guys, I have question regarding database mirroring. I have active active cluster production server and stand alone dr server, which I setup 7 db mirroring from prod to dr server. The setup was good and it has been running for 2 weeks. Today all db mirroring was gone. I got error like: Bypassing recovery for ... 10 Feb 2010 00:09

Backup Rights on All Future Databases
How can I grant the right of a login to backup every DB, both present and future. Must it be sysadmin? I suspect so ... 9 Feb 2010 15:10

Create an error to test transaction
I used SPtrantest below to test transaction. How to create an error to test and print error code? I tried to rename a column name from MYNAME to MYNAMEX and run "exec sptrantest 1" but it only displays another error message without eroor code. --------------- ALTER PROCEDURE [dbo].[SPtrantest] @id INT AS -- ST... 9 Feb 2010 18:36