Search results for query: *

I want to edit the sql query in Crystal report 10 Earlier i am calling Stored procedure (SP_1) from a repoprt. now i have to call another procedure name (SP_2) insteaf of sp_1. Please help me how to do it

I need to find a role of a user using TSQL. Like In Enterprise Mananger -->Security -> Logins-> Right click to a user -> then properties ->Database access... In that you can able to find that particular user's access right in server. Is it possible to identify this using query...

Hi How to find a user privileges to a particular table.. Like i want to find user 'vxs1' privileges to a 'testdata' table..

See my earlier respone. I want to execute grant permisstion to some tables in another server database but the same is working if we remove the servername and the database name.(Assume you are in the same server/database)

Thansk for quick response I want to execute grant permisstion to some tables in another server database. like I tried the following statement but it is not working Grant SELECT ON [servername].[databasename].[dbo].[tablename] TO [rolename] but the same is working if we remove the...

Consider I am working in Database A. Using a stored procedure I want to change the database from A to master by executing that stored procedure.. I tried this one but the database is not getting changed declare @dbname varchar(100) declare @str varchar(100) set @dbname = 'master'...

Hi Our client is going to migrate all the data from Foxpro 2.6 and also Visual Foxpro tables to SQL Server 2000. I am trying to do using DTS package.. and also help me how to get/extract memo fields into SQL tables Can any one help me on this..? Thanks venkatSQL

How to use the Global temp table in 'Transform data task properties' I'm using the Transform Data Task. That's where I declared my SQL query. Thanks S.V

Thanks lot

Hi How to check using T-SQL whether a global temp table exists or not... thanks s.v

Hi experts The below query took more time to complete the process SELECT SCC ->table Fields Value, SRD ->table Fields Value SCE ->table Fields Value, SRH ->table Fields Value, SVC ->table Fields Value FROM SCS_CONTRACTS SCC INNER JOIN SRD -- Table 1 ON SCC.icontract_id = SRD.icontract_id...

Hi Experts I want to execute function which is going to use as table like ( In Transform Data task properties - SQl Query as) select * from testven(?,?) It shows error message as Error Source: Microsoft OLE DB Provider for SQL Server Error Description: Syntax error or access violation...

Thanks to all. The above problem is happening only one tables in my database. Field struce of the the table -------------------------- table name ==> PHY_Data -------------------------- Structure -------------------------------------------------------- PHY_ID - Integer...

DB2 Experts I am newbie to DB2. I have one table called Phy_data, it has one primary key 'phy_id' as identity column. For this table i have to import the values from a textfile. Assume the text file has 10 records ok..? First time identity column value starts automatically with 1 to ends...