Sammy (11/20/2008)

---

Hi,

I have an application on windows XP that is continuously connected to my DB server by using an OBDC connection (System DSN > SQL Server).

Occasionally, when there is...

Very good link...

I'm not sure, there is no...

smthembu (11/20/2008)

---

Hi All

I need help, when i right click my computer on the sqlbox and click manage then to services & applications, i get an message box "C:\Program Files\Microsoft SQL...

use OpenRowSet to export data into Excel...

use left outer join to get the data in both tables. for more info see Joins SQL BOL.

Wilfred van Dijk (11/20/2008)

---

The following error (referring a non-existent column) is not catched:

begin try

insert into excludednames(doesnotexist, metadata) values('selectednames',1)

end try

begin catch

print 'Gotcha!'

print ERROR_MESSAGE()

end catch

This results in a severity 16, which should...

both server are in same domain or different domain ?

check the remote server settings thro' SQL server Surface area configuration (in that enable Remote Connections...)

Paresh Prajapati (11/18/2008)

---

I have to implement Database Mirroring or Log shipping on different server in which one server is located in USA and other in Hongkong..

So, which option is best...

Nandy (11/18/2008)

---

Hi All,

I have used the cursor in the stored procedure to delete the data from the table. I'm deleting the data from table where I used the same table...

could you tell what exact output of query.

try...

anshu84onnet (11/18/2008)

---

Hi All

how to give permission to the folder in which i am taking network drive back up plz tell me step by step method for giving sql...

generally, all sp's or table's grant the execute or select permission to public, so that client can access the data because of select or execute permission.

check the permissions of objects.

Andy Howell (11/18/2008)

---

It is only returning between 1 and 5 records per enquiry, and the servers are linked. In addition they are on the same hub in the...