yuvipoy (1/10/2012)

---

Hi,

Select * from sys.sysobjects where Xtype='p'-- Result is Good

Select * from DBName.dbo.sys.sysobjects where Xtype='p'--Result is

Msg 7202, Level 11, State 2, Line 1

Could not find server 'DBName' in...

How often does this database need to be synced? Could the client simply send you an encrypted and password protected zip file of a current full database backup?

Do a searh of this site for dbo.DelimitedSplit8K. You should find quite a bit of information....

Question is also here.

First, please write your code using the ANSI-92 style joins, not the ANSI-89 style joins. Putting your join criteria in the FROM clause and your filter criteria in the...

Yes, you can run reports (read-only) against a database in standby mode. No, you can't apply transaction logs while reports are running against the database in standby mode, you...

How about saving your actual execution plan and uploading it to this thread? That would help us a lot.

Agreed, and it should be the Actual execute plan if possible...

Eshika (1/10/2012)

---

An overview of the trigger - There are two databases DB1-Transactional and DB2-Archive. There are two tables from each database, Tables1 & 2 from DB1 and Tables 3&4 from...

Need the ddl (CREATE TABLE script) for the table including the definition for the trigger. If the trigger affects any other tables we will need those also.

Case insensitive vs case sensitive, one of the reasons I write all my queries and t-sql code as if everything was case sensitive. Don't have to worry about it...

Ninja's_RGR'us (1/5/2012)

---

Steve Jones - SSC Editor (1/5/2012)

---

In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had to replace...

Ivan Mohapatra (1/2/2012)

---

thnks i just want to know is image datatype can we used in any compare condition or not.

so we can not have compare condition in image datatype...

This may be what you are attempting to accomplish.

delete from dbo.phototable

from

dbo.Master_table sod

inner join dbo.phototable p

...

I agree with Gail...