Do you mean you have 1 sql server and when you run a query using SSMS on the SQL Server it is very fast, but when you run the same...

Hi,

Can you be more specific with what do you mean by data file, you want to create a text / excel file from within stored procedure, If I am correct...

Thanks for you time friends. could not solve the issue, updated the col to varchar datatype.

Thanks again.

Yes David, I have done that rather tried both 1st time only, it returned no records.

I have a space on the right side so changed the query accordingly . but afraid it shows no records.

SELECT DISTINCT

[Code]...

I get he below sol.

87[W]

tried to directly update with 'WDT' even that is not wokring for that records. running out of ideas.

the problem that I am facing with this is application is using colname= 'WDT' and I have 10 records against that value out of which 9 were inserted earlier and...

Lowell,

Thats the expected behavoiur fine, but the point here is, maybe for example I can put it like below. The column is of length 5. and I have more than...

Hi,

you can right click on the server, and in one of the tabs over there you can enable logging and you will have to specify a location where you will...

Hi,

You have analysis services log also, what does it say?

Regards,

Sriram

Hi,

syscolumns is the table where you will get the text of the stored procedures, would better go for some 3rd party tool for me to create a documents, you can...

Hi,

you can get the details from the below, filter it as per your requirement

select * from msdb.dbo.backupset

Sriram

you can get the details from sys.objects or by running sp_tables.

select * from sys.objects where type = 'U

Regards,

Sriram

Hi,

Maybe you can check this approach.

Have a sql table where you can store the last value and get the value from there using a dynamic properties task or from withing...