| Thread | Last Post | Replies |
|
| Best practices for error handling in SQL Server procs | 01 Dec 2008 20:50 GMT | 25 |
One of our clients has just developed a set of coding standards for their .NET and SQL Server application development. For the SQL Server standards, they say the following regarding error handling: -----------start of quote---------------
|
| SQL Server to Microsoft Exchange | 01 Dec 2008 19:23 GMT | 5 |
I'm not sure if this is the right group, but I'm looking for information on how to get our Contacts database (which is in SQLServer) into a Public Address book on Microsoft Exchange. I trawled the net and found the following article on SQLServerCentral...
|
| Database Mirroring not synching till I open Mirroring Monitor | 01 Dec 2008 19:19 GMT | 5 |
I'm rather new to mirroring, I had to setup the princible and the mirror using certificates per the example in BOL. I am using asychronous mode. Everything looks good till I launch the Database Mirroring Monitor. In the left hand side it will say Time to Send Log
|
| Alter Index On Database Rebuild (SQL Server 2005) | 01 Dec 2008 07:48 GMT | 5 |
I have a SQL Server 2005 database that I am trying to rebuild the indexes. I used the ALTER INDEX ON TABLE_NAME REBUILD on each table. After completing this task I ran the DBCC SHOWCONTIG on each table. I noticed the logical scan fragmentation is set between 25 - 80.
|
| Migrating SQL 2000 to SQL 2005, any risk I change db collation too? | 01 Dec 2008 07:35 GMT | 7 |
I am restoring SQL 2000 databases to a SQL 2005 SP2 where the SQL server's collation is Latin1_General_CI_AS. The SQL 2000 database backups that I am restoring have their collation as SQL_Latin1_General_CP1_CI_AS.
|
| Trigger and Misc. | 30 Nov 2008 21:05 GMT | 12 |
We have a few issues that we hope to get some information on as follows. We are not sql gurus and are learning on the fly (not the best, but we have to deal with this on a day by day basis while we interview SQL dbs). A) We have a DB that looks like this, we inherited this from a ...
|
| Lumigent Log Explorer - where to get it? | 29 Nov 2008 15:42 GMT | 26 |
I have been asked to recover an SQL Server 2005 database which has had data accidentally deleted. There are no backups :-( I tried a demo of Apex SQL Log and it looks like it will recover the data but it's quite expensive and I'm looking around to see if there's
|