SQL Server doesn't manage remote dependencies.

Adi

Cursors have bad reputation, but in my opinion it is more because they are being used where they shouldn't be used. There were many cases in the past that...

Actually you can define a different file group for BLOBS when you create the table. Take a look at CREATE TABLE statement and check the meaning of TEXTIMAGE_ON. ...

Here is one more way:

;with MyCTE as (

select HotelId, RoomTypeId, cast (DateKey as char(8)) as DateKey, FreeCount,

row_number() over (partition by RoomTypeId, case when FreeCount = 0 then 0 else 1...

When you build replication, the server creates stored procedures at the target database. The procedures have name that looks like this sp_MSoooXXXX. The ooo is replaced by...

One more option that might be good for you is to use the compute clause. This will create 2 separate sets of data (one with the real data and...

Obviesly as you wrote it would be much better to use an XML column and not store the XML as string. Having said that, depending on your text in...

If I understood you correctly you need to create an identity column for the ID and the date column can get the value of getdate() when you insert a record,...

Any character is greater then an empty string. Most chances are that the developer that wrote this statement wanted to get back all the values that that don't have...

Most chances are that you have 2 strings that look the same, but there are some characters that can't be seen. Take for example this code

declare @tbl table (vc...

asm1212 (5/30/2012)

---

It was set by ENCRYPTBYKEY...

So there is not a way to disable that so when you insert a record, it goes in as a regular number? So what happens...

I'm sorry but I don't understand what you need nor how your data looks like. Pleas write a small script that creates the tables, insert few rows into the...

SQL Server has build in error messages, that are stored in sys.messages table. A DBA can add more messages to this table using the procedure sp_addmessage. If...

I'm sorry, but I don't see any errors. What I see is a code that checks if an error exists. If it does exist it drops the error...

Are you sure that there are clients that don't use the Anonymous login?

You didn't write anything about how you insert the data. If you insert it...