quote:

---

Hello evrbody,

I've used to SQL Server 6.5 ...

I've had some problems...

I want to make my own SQL procedure which..

execute dynamicly created sql...

I would avoid timestamp for the fact that this implementation is not ANSI-SQL 92 comparable and as stated in BOL

quote:

---

A future release...

quote:

---

first of all thanks guys for quick reply. really appreciate it.

Ok antares here it is the details:

suppose users want to see...

quote:

---

One thing you might try is to script out all your tables using EM, edit the DDL to move the tables ...

I still have concerns over scripting out doing this. Here are the base steps EM follows minus a bit I know I am missing.

Collect Permissions

Collect Triggers

Collect Extended Properties

(other pieces I...

Going back to this, this is my first reaso for concern with using a SQL Timestamp type.

quote:

---

The Transact-SQL timestamp data type...

Unfortunately, SQL does not have a direct TSQL method at this point (I know at least one person has put on the wishlist but send a wishlist request yourself for...

Yes, I meant column_name. I am just used to using col when referencing with developers here. Sorry.

Another thought, if your database is very large keep in mind the backup will be fairly large too. If this is a concern and a factor in why you wish...

Even then the time it is taking will still be the same. I think the other method is still going to take a bit but you can do i in...

I agree with the trigger except keep in mind it will increase transactions. You would be better to wrap query in an SP and have it done there to eliminate...

Did you open the job history to see what the failed message is all about. The fact the snapshot suspended is just that it could not run. Check the job...

BACKUP DATABASE [dbnamehere]

TO DISK = '\\server\share\path\filename.bkp'

WITH

(see options for Backup Database in SQL BOL)

Then beyond that you have to make sure the remote machine has proper rights on the share for...

It is not an inconsistency as the queries specifically ask for different results.

Think about it:

quote:

---

The orderId= 10248 does contains just productId =...

quote:

---

Can bi-directional replication be established on the same table?

---

Yes. With Transactional Replication you set publication...