Install SQL Server 2005 native client and then create a DSN then create the linked Server with it and change the query time out value also it should be 250...

is there any identity column in both table

select c1,c2,c3,(select top 1 c1 from table2) from table1

if you dont have any column which can be join then it must be an...

declare @test-2 varchar(300)

set @test-2 = '10,11,12'

set @test-2 = REPLACE(@test,',',''',''')

set @test-2 = ''''+@test+''''

print @test-2

It will create for the IN operator

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE...

You can check SQL Server built-in reports for TOP CPU usage and TOP IO usage reports then these type reports can help you to find the correct database for the...

First of all check the SQL Server service is started or not in the SERVICES then open the SQL Server configuration manager then check protocols as well like

TCP/IP

SHARED MEMORY

NAMED PIPE

If...

You should watch for 2 days to find increase size per day

Example

on the First day your database size at 1:00 pm is 80.78MB and on the Second day database...

Yes, It will create the backup of a table

SELECT * INTO TABLE_BAK_ FROM TABLE1

Regards,

Syed Jahanzaib Bin Hassan

MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA

My Blog

http://www.aureus-salah.com

Use single column name againts (*)

Regards,

Syed Jahanzaib Bin Hassan

MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA

My Blog

http://www.aureus-salah.com

SQL Server 2005 SP4 is available now

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece

Regards,

Syed Jahanzaib Bin Hassan

MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA

My Blog

http://www.aureus-salah.com