You can simply use SET QUERY_GOVERNOR_COST_LIMIT in the login trigger. You can check the currenttime of the server in the trigger and if it falls in your peak hours, set...

Try Using INFORMATION_SCHEMA.TABLES

It contains the tablename and the schema.

It also contains the list of views in it with TABLE_TYPE = 'VIEW'

Atif Sheikh

I havent tried to install SQL 2008 till now. Waiting for the Full and Final release. Would definitely take help from the video while installation.

Nice work...

Atif Sheikh

eerkan... your solution misses one record

Try again...:D

Atif Sheikh

GREAT ARTICLE...

Alot of learning points in it...

My First thought, I would have gone for cursors to solve the issue. Secondly, I would certainly NOT go for the conversions as...

If the the requirement is that you want top 1 record against each Duplicate ID in your stage table, than the solution above should work. Otherwise, can you please post...

Also, working at home also depends on the policy oif the company you are working in. If it is a bank or even a Software development firm, the don't and...

I drive for 15 minutes to get to my office. Working at home can be benificial if you dont have kids OR the are school going. Mine are too young...

In our application, we send the data from PDA to the Server (Gateway in our case) as soon as it reaches the PDA. PDA also keeps the track of the...

You are right Grant. I was just making clear that IDENTITY column may have duplicate values IFF the IDENTITY_INSERT is set to ON while inserting a record OR if RESEED...

read the following article for your answers...

http://support.microsoft.com/kb/322112

I think it will give you a better understanding...

Atif Sheikh

Ok.. Found the tool to do so. Try SqlAssist. It is possible in it...

Atif Sheikh

I wonder why the article is dated 2001/07/25. Is it that old...? Any ways, somewhat information for me (at least) about Datatect 1.6. Will use it to see what it...

It will be very convinient if you post the sample data

Atif SHeikh

I simply created a table with a float column and inserted the records in it as

INSERT INTO Tab2 (ff)

SELECT (0.003 / 100000) FROM Tally a ,Tally...