create table #foo (I int,n varchar(200),o varchar(200),p varchar(200))

insert into #foo

SELECT 1, 'JAMES', NULL, NULL UNION

SELECT 2, NULL, 'CA', NULL UNION

SELECT 3, NULL, NULL, 'abc@hotmail.com' UNION

SELECT 4, 'CAMERON', NULL, NULL UNION

SELECT...

--------------------------------------------------------------------------------

This is the Table structure I have I want to write a query to the get the

col 1 Col2

1 A

2 B

3 C

4 D

5 E

6 F

I have a table with...

I guess when updating the statistics the statistics will be updated based on the column not on the object.. Im I right Lowell

In SSMS, Connect to Server pane I'm giving the details as 192.X.X.X,PortNumber this is what Exactly I'm giving in the Server name with Windows authentication. For Default instance when I...

I'm using SQL Server 2008 server and coming to finding out the port number I'm using SQL Server Configuration Manager.

For default instance when I try to connect using I/p...

Yes, my mdf(datafile) is in one drive and ldf file is another drive.

Coming to the full backups they are taken for every 12 hrs and transaction log backup is...

Cool Got it!!!!!!

Appreciate you all for your response ..

but can any one tell me how to overwrite a already created database with a backup file.

Thanks & Regards,

Ravi Shankar