Hello all, I am working on a task in which, I need to generate XML output out of a SQL Database. I am using FOR XML clause and generating output...
Does anybody know? how to create a report in text format or any other custom format from Reporting Services?????I couldn't find any way doing...
Hello all,I am trying to set Language setting for a filed in my table dynamically. I have an expression which decides which language should be there...
Hi,I have to compare two different versions of a sql script and need to find out differences between them. Is there any sql tool out there for this...
Hello Everyone,I never used NOLOCK hint with select command, I have following question.If I issue NOLOCK hint on one of the Table[Table1] inside my...
Hi,I started working on SSIS Package recently, I copied one working SSIS package, and modified VB.Net Script behind it. One SQL Server Job is calling...
Hi, I have a problem with my Report Model. I've added the data source, the SDV and the Report Model. It has been deployed to the server. I go to...
Do we have log file for SSIS package, I have a sql server job in SQL server 2005 which is executing SSIS package. Now, Job fails sometimes and...
Hi, I came across a situation in which i have to create a job on one server which will fetch data from the database of different server and bring...
Separate names with a comma.
