Search results for query: *

Can anyone tell me how to set query timeout. I have a stored procedure running with select statement I want to include a timeout option if the query runs for more than 3 minutes ,only for this procedure not at server level for all procedures. Can anyone tell me how to do this Thanks Sparkme

I have a user called Report in a database.I want to find all the stored procedures on which this user is having EXECUTE permission in the database. Can any of you tell me which system tables and how this can be queried? Thanks

Hi, THE SQL Select 100/30 is returning 3 in query analyser I want to see 3.33 (i MEAN WITH DECIMAL VALUES) CAN ANYONE TELL ME Thanks

Sql Friends , I want to write a sql query to order the daily orders by date as well as number of orders per hour.Please help. Thanks Spark

Can anyone tell me how to update identity column example id is identity colummn in author table i want to update author set id = new value where id = old value thanks

Is there any script in sql to insert excel file like to insert the output of the following query select * from authors I know I can do this from DTS but I want to do from sql query. Thanks

Can anyone tell me how to move Jobs between two SQL servers? Thanks

I want to start MSDTC under Cluster environment in Static mode, It was starting in Random Mode which I dont want.Can Some one help me Please .....? Thanks In advance.

Is there any way we can find the last time a stored procedure was executed? Thnaks in advance

I have a Excel file Called Customerdata with data in one sheet called data value(There is another sheet in the same Excel file) This Excel sheet is in my Local drive C: Can anyone tell me the syntax to fetch the record from this excel file (FYI) the following code is not working: SELECT *...

I have a Excel file Called Customerdata with data in one sheet called data value(There is another sheet in the same Excel file, This Excel sheet is in my Local drive C: Can anyone tell me the syntax to fetch the record from this excel file the following code is not working(FYI) SELECT * FROM...

Hi, There is a TABLE called PERSON ,A column called Person_id is primary key column in that with data. Can some one tell me how to alter this column to be a Identity column ,Basicaly a I'am looking for ALTER SCRIPT. Thanks

Can someone help me in this..... Table name-customer Customerid custname flag parentid 1 A I 0 2 P I 0 3 B S 1 4 Y S 5 5...

Helo Everybody, Can Anyone tell me Few Differences(Features or/Advantages one over the other)between MSSqlserver and Oracle ? Thanks Sparkme...

Helo, I'am learning VB 6,Can someone tell me how to call sql server stored procedure with TWO input parameters like @Name ,@DOB , After making database connections? Also if you can suggect me a real good book to learn myself VB 6 (Project oriented)thatwould be great. THANKS IN...

I was trying to Insert into a table from a text file bulk insert dbo.Client from 'C:\Client.text' with ( datafiletype = 'native' ) I'am getting the following error: Server: Msg 4866, Level 17, State 66, Line 1 Bulk Insert fails. Column is too long in the data file for row 1...