You don't.  It's really as simple as that.  Think about what you're saying here.

How do we retain the ''(Empty string) value when passed in float data type?

string....float/float....string   They are...

SQL Server Books Online gives the following reasons to sometimes convert stored procedures to UDFs; and I think they give a good beginning on how the two are different from...

Don't use autoshrink.  It sounds like you are not doing transaction log backups so set the recovery mode to simple.  Also, don't use Veritas to backup the databases if you...

The master and msdb database should be backed up minimum of every day also.  They are so small, I don't know why anyone would not do this. 

urrrrr, well you can't win anyway then, so time to find a new job. 

I like having:

NT Users---->NT Group---->DB Role---->ApplicationUserTable

NT User---->NT Group gives HR...

If there are any procedures in the master database, they should be items that need to run against all databases for maintenance, etc.  This should be kept to a minimum...

You could export to a text file and use UltraEdit32 to compare the two.  I prefer

SELECT * FROM dbo.table t1 FULL OUTER JOIN server.db.dbo.table t2 WHERE t1.col1<> t2.col2 OR t1.col1  <>...

We're a Compaq/HP only shop and I have 22 SQL Servers.  I have Insight Manager running on most of them and haven't had any problems.  The MSA 1000 shouldn't make a...

Look at Nigel's work on hierarchies and see if that solves your problem.

http://www.nigelrivett.net/

Yes.  You will need to install SQL Server on a new machine and run the RESTORE DATABASE command to restore your database from the backups file.  Here is an example...

If you are not doing transaction log backups, you need to set your recovery mode to simple and just run

USE database(whatever database it is)

CHECKPOINT

DBCC SHRINKDB()

in Query Analyzer.

To get...

DECLARE @totals TABLE(

 Code CHAR(4),

 Amount MONEY,

 Year INT)

INSERT @totals(

 Code,

 Amount,

 Year)

 SELECT 'AAAA',100000,'1998' UNION ALL

 SELECT 'AAAA',200000,'1999' UNION ALL

 SELECT 'AAAA',300000,'2000' UNION ALL

 SELECT 'BBBB',100000,'1998' UNION ALL

 SELECT 'BBBB',100000,'2000' UNION ALL

 SELECT 'CCCC',100000,'1999'

SELECT

 t.Code,

 t.Amount,

 t.Year,

 (SELECT SUM(Amount) FROM @totals WHERE Year <= t.Year...

Can you ping the server?  Also, have you tried connecting by the IP address of the server to see if it's a name resolution issue?

Do you have the latest service packs installed on Outlook and SQL Server?  Also, do you have other people accessing the server (through terminal services for example).

You never said whether you can send a message from Outlook.  Can you?