It depends on your SMTP Server and Network Usage.. Leave the values to default which will work for Ideal situation... You can take the help of your System Administrator for...

RDL file can be download from this link

http://www.sqlservercentral.com/Forums/Attachment1344.aspx

Thanks for all your feedbacks!

Hi,

Not sure about this situation.. But normally when you do below command

telnet sqlserverinstancename 1433 (Assuming 1433 is the port in which instance is running)

you will get black...

Paul,

Somewhere I read like... We can change that database to emergency mode and restart the server so that it wont look for LOG files and then build...

Hi,

Check the SMTP Relay Server Settings to which you are connecting.. There is a option in the SMTP Virtual Server to limit the connections and this is...

You can check this by copying the mdb to local drive and use Admin as username and see whether your linked server is working...

Thanks Glen for your inputs...

Hi,

You have not specified which SQL Server you are using... Anyways the method is same...

Hope you can go till create new linked server...

Now in the provider name...

I'm not sure whether this will help you... Just give a try..

For example take ASP as front end..

Declare two connection strings with one pointing to Old database and other...

Hi,

This piece may help you

-- Code to get SQL Server Version

-- Author : Sakthivel Chidambaram

-- History: Added 9 for getting SQL 2005, Add for SQL 2008 if...

Hi,

Go to Administrative Tools --> Component Services -> Computers and Right click My Computer and select Refresh all components and see whether you are getting Any Error...

Some useful links which i have regarding your query...

Using LOGNAME Parameter to get output from one time installation and later you can use them in your template.ini

http://www.devx.com/dbzone/Article/31648

Some experiences of Unattended...

Some more points adding to previous reply...

Database Snapshots are available from SQL 2005.

It is available only in Enterprise Edition.

Snaphshots will create Readonly database which cannot be UPDATED..

Database can be restored...

Ram, How about reply to other two questions? Also Maximum Memory Configuration is in SQL Server options and it is not Virtual Memory which you have given...

Hi Ram,

Is it a 64-bit server? Seems like HardTrim is happening because OS finds that Low memory condition.. Can you try below things?

1) Setting a limit for...

I guess you have already changed the authentication mode to SQL Server Authentication... So now you will not be able to login through Windows Authentication... So unless you get correct...