Executing it for 50 columns took me 2 minutes. You can estimate the time taken for say 1000 columns.

I cannot keep the user waiting for that long. Thats why i...

woww!

you guys are awesome.

This really puts me into thinking about some alternatives like creating views 🙂

There are a few restrictions. I don't know whether they are really some restrictions/problems or...

Well, Good. That was a really good start.

This query can be used to observe values changed within a table.

Welllllllllllllll

My scenario is a little bit different. I need to put that...

Ok, here is the code below. Let me explain once again.

I have a bunch of tables in which data is populated daily, and data may vary, data may change for...

well "overkill"

?????????????????

Whats the alternative then?

because alternative people over here are mentioning are not working for me.

"EXEC @sql;" doesnt work in a UDF and if put in a stored...

ok guys, i figured it out.

problem resolved.

what i did was that

1.i changed database owner from "administrator" to a database user like "sa"

2.set the trustworthy open to true

3.Recompiled the assembly...

oh man ! you are missing a point.

i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" are variable. they...

firstly, i have mentioned DataAccess.Read at the top.

then why do is a CLR needed. here is the answer

i have a table like this

table=mytable

table_name column_name value

tableA col1

tableB col2

now the "value" column...

hello guys, i was busy on another project, and now

I AM BACK TO TH SAME PROBLEM

Please give me an idea on this.

well!!!

i am only able to run following

ALTER ASSEMBLY sqlserver_pat with PERMISSION_SET=SAFE

while

ALTER ASSEMBLY sqlserver_pat with PERMISSION_SET=UNSAFE

and

ALTER ASSEMBLY sqlserver_pat with PERMISSION_SET=EXTERNAL_ACCESS

gives me error.

ANDDDDDDDDDD, Safe permission set doesnt solve the problem either, can...

select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=\\10.114.0.50\shared\tar\PAT_INFO_OUTPUT.xls', 'Select * from TBL_CIC_INFO_OUTPUT')

this is the command. and that works fine if the server is restarted. but, restarting it daily isnt the solution that...

well. thats great problem that i have too short deadlines that i cant consult any book right now.

Anyways, i got it working, i did the CLR integration and that was...

please give me an example. i tried but am unable to write such a function, but that not working.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

create function [dbo].[udf_PAT_changes_value] (

...

hmmm, i think thats a good feature in mysql.

anyway !!!

there are other solutions. thanks for that !!!

Well, well !!!

i think i was unclear.

what i meant was that constraint should be enforced, but a constraint being violated should not give an error and terminate the execution, rather...