I think we located the problem...

When we used a remote server application (since the server is a branch server far from our location) the windows interface is not responding...

Thanks for the replies guys

@sql ORACLE - Yes, xp_cmdshell exists in that server. I'm also using the sa account

@dev - I tried both (execute using linked server and directly on...

Did you try 'C:\Backup\'?

Or use OPENROWSET

example :

select * from OPENROWSET ('Microsoft.jet.oledb.4.0','excel 8.0;database=path','select * from [sheetname$]')

*note that datatabase=path must not have space in between and sheetname is the name of the sheet inside...

Chris Morris (7/18/2008)

---

CREATE TABLE #TableA (KeyID varchar(20))

CREATE TABLE #TableB (KeyID varchar(20))

INSERT INTO #TableA

SELECT '11111.001' UNION ALL

SELECT '11111.002' UNION ALL

SELECT '22222.001.01' UNION ALL

SELECT '120394.001' -- ADDED DATA

INSERT INTO #TableB

SELECT '11111.001.05.05'...

Hmmmm is this what you want?

1. what ever value in TableB which can be seen in TableA must NOT be printed?

Example : TableB = '120394.00%' IF...

A little bit off topic...

It that a mmorpg game?? whats the name of the game??

If ever happens that you need to find a specific column name and what table is it from all the databases in the server you can use this..

CREATE TABLE FindColumn...

Did you try executing a statement like this one?

INSERT INTO X.Y.dbo.table1

select * from table2

wherein you are in the server where table2 resides

What I understand is this :

1. a.keyid = b.keyid -- WILL NOT PRINT

2. a.keyid = LEFT(b.keyid,9) -- WILL NOT PRINT

3. (a.keyid <> b.keyid) AND (a.keyid <> LEFT(b.keyid,9)) -- WILL PRINT

DECLARE...

I remember 1 scenario last year when we migrated a prod server from version 7 to 2000. The migration is successful but after users login the system they begin sending...

If you are using linked server you can use this syntax :

exec [linked-server].db_name.dbo_owner.sp_msforeachtable 'select ''?'' as ''Table_Name'',count(*) as ''Table_Count'' from [server_name].db_name.?'

If you are running from the local server you can...

Well I've tested the script in my database with almost as alike as your backup file name and the values in the old path and new path doesn't have any...

What version of sql do you have?? is it 2000 or 2005??

Can you please run the script below and send me the result. Just want to make sure that the...

Thanks Kenneth I've never handled mssql 2005 before so i can't test the script if it will run in 2005. But as what you've said it works with a simple...