Ian, is right that usually if you want unidirectional replication, transactional replication should be the best option. But there are cases that that's not possible g.e. if you have tables...

I also found the wording of the question a bit dubious. How should I know what somebody tries to achieve. It wouldn't be the first time that someone executes a...

Oops, stupid mistake

Madhivanan, thanks for correcting me.

When you add an image to a report you can choose if it's embedded in the report or not. In the second case you need to upload the image to...

The image data is still in the original filegroup. De clustered index only contains a 16 byte pointer but not the whole image. You can define the location of text...

I hope this teaches you not to change systemtables anymore, especially when you don't really know what you're doing.

The only option you have is to restore the database. Just...

Is this a question ? What do you mean by RPC issue? Why did you call this post "Replication"?

The system time is depending on windows. It's not something you configure in SQL server.

See here how to sync the time between windows servers

http://support.microsoft.com/kb/816042

You should definetely use a stored procedure because like that you can contril the permission necessary. Normal users don't have enough permissions to make backups. By ussing the EXECUTE AS...

Run DBCC CHECKTABLE to get more info about whatis wrong.

Since you want to drop the table anyway you can also use the option REPAIR_ALLOW_DATA_LOSS

shiwani2002sg (11/13/2008)

---

if i have some values like

aa ???

dd

jukin ???

kdf ???

dfe

de

d ???

now i wish to extract values having ??? at the end but extract them without ???

like i want...

I think the problem is that you try to use the error message. Did you try to use the error number 1480 instead?

EXEC msdb.dbo.sp_add_alert @name=N'Database Mirroring',

...

Yes, each instance has it's own cluster group with virtual ip address and name.

In SQL 2005 I would go with Event Notifications for CREATE\ALTER\DROP Login. You could also use DDL triggers, but Event Notifications is more suited if you want to send a...

Yes you can have SQL 2000 and 2005 instances on one cluster as long as each of them is in it's own cluster group. I've done it a couple of...