Hi

This entirely depends upon what your requirement is, can you please let us know what you are trying to...

just as an aside you can have a trace at the particular time when you get this error, this will help you to reduce overhead on servers if you are...

Try to configure on SQL Tools to allow remote connections, this might have been disabled, can you connect from the server, i mean to local server 🙂

HI

I would set the maximum Memory to 6GB and leave 1GB for OS, this is the case when you have only SQL server running...

Technology in general brings to a stage where you cant get far away from work, i personally believe on WORK - LIFE Balance, there are times when problems with my...

use convert function and you can do this. look for Convert options in SQL BOL , hope this helps 🙂

Hi Mike

It all depends upon the data that you need and the sensitivity of the data, some companies don't...

Thanks Jack for this, i think i will ask the developers to look into the codes and get me the table names, let me clear from where its started (...

Thanks for reassuring me Jack, Is there any way that i can find which tables are been used, and id i have stored the database on a LUN, will this...

Thanks mate, just to mention i used SQL Management and then opened the design of table from menu, then changed the Idnetity spec option to No and tried to save...

Hi Reddy

Will this work on 2008, since i tried the same on 2008 management studio, it gave me an error...

Hi

There are lots of papers that help you to setup this, one example is

http://search.techrepublic.com.com/search/microsoft+sql+server+2005+and+mirroring.html

Hope this helps 🙂

Thanks Every one for the replies, I have used Export wizard in the past but once the table has been moved i script all constraints , i never used SSIS,...

Hi Erik

This seems to be working, but one part of this is that we use Java as a front end, there is no driver...

Hi Sam

If you have a problem with Excel, tehn you cant you just import the excel into a table...