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...
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 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, 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 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...
Hi friends, I have a code like this. when i execute in Query analyser I am getting Error. Please advise me. Declare @cmd sysname, @rc int, @var1...
Hi friends, Can i pass Dynamic values in a sql query which in turn used in bcp utility. Regds Sailu
hi Friends, which formats of XML does SQL supports? Please advise Regds Sailu
Hi friends, One of the applications I am using bcp utility and My question is I want same .txt file to be used for all the queries, i.e. The...
Hi Friends, I have a task of writing a Stored Procedure which takes a value dynamically and fetches the data from SQL table and places in a EXCEL...
Separate names with a comma.
