I ultimately could not get thru this code... I checked out all possible ways. But the openquery does not allow to create tables within the stored proc... I still dont...

I have been able to reduce the scope of the error. I face a problem only when and only in procedures where I use temp tables.

For example:

Procedure on...

Please check for single quotes while storing data in SQL Server(rather any other database). You have used single quotes in between the text that you want to send as mail....

The problem that I faced while using transactional repliaction was that I could not insert new records into the subscriber db (target db). I am setting up 2 way replication...

Do we need an empty database to set up Merge Replication or can we setup merge replication on an existing database with data in it?

Replication is failing on the...

Rapid SQL seems to be a nice choice! Nice functionality... I still need to explore but its the little that I have seen impresses me

Paras Shah

Evision...

Clearer Please!

quote:

---

Vannessa

It is possible to do this with a single query. I'll give you a hint; it involves a two step...

Any way to restrict this access! This is sometimes too dangerous!

quote:

---

Use:

sp_password @old = 'Old PAssword' , @new = 'New Password', @loginame...

Is there anything other than InterDev... as interdev is too heavy to use only for debugging SQL SPs. Please reconmmend.

quote:

---

Visual InterDev has...

But usually telnet access and PCAnywhere access is not given to users who have shared hosting services.... then whats next best?

quote:

---

Do...

Is it safe making vbs scripts... some servers would not allow running scripts for security reasons... so please cheeck and the server where the application is being ported/installed.