skb 44459 (12/4/2014)

---

Table to Update is CustomerCredit

- Fields are CustomerNumber, CreditLimit

Validation Table - UserAuthorization

-Field UserID, Password

I am writing an asp application where Fields on the asp form is CustomerNumber, CreditLimit,UserID...

If your requirement is such that terrible performance is acceptable, there is. Are you...

manju.ccc (12/4/2014)

---

Yes Phil all servers are identical. There are three servers in three different locations. One is publisher and other two are subscribers. OS is windows 2012 and SQL is...

Jason-299789 (12/4/2014)

---

IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer.

to get round...

manju.ccc (12/4/2014)

---

Hi spaghettidba,

Thanks for your reply.

Ok I got your point.

But I have two servers with same environment.

This problem occurs only a database of one server other one is ok

One...

manju.ccc (12/3/2014)

---

Dear friends,

I have a table which is using merge replication.

So when I update the table by simple update query then i'll take more time.

Then I run same query by...

Sure.

Take a look here for an example.

Unfortunately, it's heavy on CPU and slows things down quite a lot.

Debbie Edwards (12/2/2014)

---

Integration Services.

Hmmmm I shouldnt think its permissions. I have all the right permissions set on all the folders the job needs to access. But I could be wrong....

Both Redgate SQL Compare and VS Schema Compare provide the ability to preserve data in the case where object renaming has taken place.

In the case of SQL Compare, this is...

May I ask what you mean by 'IS' in this:

Could it be a permissions issue?

True, but that does not demonstrate the 30 character problem.

Jason-299789 (12/2/2014)

---

MS don't make it easy for people from BOL

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is...

BI_NewBie (12/2/2014)

---

OK!!

Below is the way i am following :

1 Created three variable Query, Sdate, Edate

a. Query = SELECT * FROM Table where date<=...

select @variable

princessthedba (12/1/2014)

---

I mean this. Assume I have 2 backup dates for hostname "c" and 3 backup dates for hostname "d". And the table is like that:

hostname last_backup

c ...