By Inserting manually I am getting 1 but when I am executing through SQL SP I am getting 0. I am pasting the SP code too IF...
CREATE TABLE ProOrganization ( OrganizationIdentity INT IDENTITY (1, 1) NOT NULL ,OrgId NVARCHAR (50)NOT NULL ,OrgNameNVARCHAR (256) NOT NULL...
Hi All I am using the IDENTITY(1,1) for one column in a table creation and after then I am executing an SP, Surprisingly the column for which i...
Hi all, I would like to know what are the user permissions set for the SQL jobs?? Is it mandatory to have an Administrative privlege for the user...
HI All Thanks for all ur suggestions. The problem ariased due to the deployement issue in the build. One of the configuration file was missed...
Thanks for all your suggestions. The problem got resoolved
job calls .exe ( written in C#) inturn it calls SP's in the code and this SP will fetch the data from Database in the form of XML.
Hello All I have a SQL job which I am trying to run with Administrator. But I am unable to start the job and it is failing always. No error is...
HI All I am using UnionAll in my SP which i combining 8 to 9 Sql statements inorder to get some reports in the form of XML for which I am using...
Hi Ravi U can migrate the data using Stored Procedure and call a job and schdule it.Data Migration should be done by using Timestamp from...
Hi friends, I have one cmd file and i need to schedule this cmdfile in a job.. how to do? should i need to use bcp or anything else. Please let me...
Hi friends, I am using the following query to export data into an Excel sheet. My Question is I want the column names also to be included in...
I am executing a DTS package in which I am calling a Stored Procedure and that Procedure has so many Select Statement from different tables....
Hi friends, I have an xml file which has format like this <newdataset> <user> <id>1</id> <Name>John</Name>...
Hi friends It still hangs. Otherwise give me solution how to open a file from SQL server. Please give ur suggestions. I am using the Winxp...
Hi friends, I am using this code to open a file through SQL server using the "call Command". But when I am trying to execute the Sql server is...
Hi Satya, I want the the contents of one file gets into another file by just writing only the File name not the each and every content of the...
Hi friends I want to append the contents of one file into another file using SQL query. I have used xp_cmdshell. But i could not make the copy of...
Hi friends I am using a query in xp_cmdshell. when I am trying to execute the query I am getting an error Query hints exceed maximum...
Hi friends I am having an Source code in which all the contents are getting appended to .txt file through bcp utility. I have pasted this...
Separate names with a comma.
