Yes, I understand that backups will not lock. I need more information on how to troubleshoot this and eventually fix the issue.

We are currently using a CLR function to make HTTP Post. Which is better?

Thanks

KRS

Hi all

I have a similar scenario, two servers and when data is inserted into 1 database table, it has to be inserted into table in other database,

Now, i...

Can i use CREATE INDEX WITH DROP_EXISTING.

It is an non-clustered, non-unique index. When I try rebuild, the database itself is locked and no other actions can be performed.. Pls...

Yes, that was a great mistake to disable it. but how to rebuild index without slow down other db actions

Nice.. Just a thought striked.. NoSql in SQLServerCentral?!

Sorry. I need to give more info on the environment. The common database and all databases ( 4 or 5 ) using the common database are in the same server...

How could i get the filename in package variable defined. I need folder name also.

Basically I try to insert data from excel to sql table. Along with the data, the...

Thanks for the comments

1. @clauses are valid and safe, I'm sure

2. No.. Couldn't do that, the first IF check is to skip the execution and direct selection, but with the...

Thanks for the reply.

Sorry I missed the 'Order by' clause. The select is ordered by the clauserank column.

Yes. This is not actual code. I cann't publish it.

The whole Idea...

But here the clauses are ordered by clause rank. If the highest rank does not satisfy only, we will move to the next clause.

Also, I should know the row...

[Code]

declare @tablevar table ( tvid int, clause varchar(100), clauserank tinyint, val int )

insert into @tablevar select * from vallookup

select top 1 @tivid=tvid, @clause=clause, @clauserank=clauserank, @val=val from @tablevar

while (...

Will this give performance boost

Absolutely right.. Every one has their unique values and skills.

Really motivating topic.. Thanks

Thanks.. Now I understand.

I was wondering what happened to '-'

Also, why not it work like this:

'-' being string,

other two can implicitly convert to string?