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

I came to know that There is No need to add a column on the basis of Datetime value I can use the function in the SELECT DATEPART(hh,DateAdd) and group by DATEPART(hh,DateAdd) Thanks

Friends I found the answer to this by myself.I added a column to the table (Table variable for temp result) called DateId Which will be having id on the basis of DATETIME VALUE in the Order table Then I can order on the basis of DateId

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

NO SET IDENTITY_INSERT TABLE author ON WILL WORK FOR INSERT BUT NOT FOR UPDATE

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

thanks for the reply. I want to move sql server Jobs between servers not Dts packages. Can anyone tell me how to move Sql server Jobs between two servers ??? 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.

Thanks again for all the replies. There is no entry in master.dbo.syscacheobjects table to find last time the proc was executed . The only thing we can do is to create a Log table and insert every time the proc is executed .

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

Thanks for all the replies to this thread now I got the answer.... SELECT * FROM OPENROWSET (''Microsoft.Jet.OLEDB.4.0'', ''Excel 8.0;DATABASE= C:\Customerdata.xls;User ID=Admin;Password='', ''SELECT * FROM [data value$]'' ) Thanks

Hi Thanks to all your replies! I have totally 60 Excel files which loads data into 150 tables, If i use DTS i have to create 60 packages, Instead if i write one program(script) which can be something like what i mentioned earlier FYI SELECT * FROM OPENROWSET...

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...

Thank you so much!

Hi ESquared , Thanks .But the script generated from there drop and recreate the table . I dont want to drop a table because i will lose data. So i need only just alter script to change a column from ordinary to a column with primary key having IDENTITY