Thanks for the reply. Yes, its only a SELECT and does not include any Update/Insert.

Yes steve, thas the approach i am currently using... i.e. using bulk insert. But is there any way to load/separate only the last line either through SQL query or in...

Right-click SQL Server Agent, and then click Properties.

Click Alert System.

Select Enable Mail Profile.

In the Mail system list, select Database Mail.

In the Mail profile list, select a mail profile for Database...

1. Increase the query timeout period in Tools-->Options-->....

2. Otherwise create a tbl with same structure but with datatype changed for that field and then insert records into it. then...

But the code has "drop table" part which should delete the table and create it as a new one. It was running previously without any issues. Also it runs under...

Did you try using the UNC path instead of D:\. Also does the .bak file exist in the given path?

am trying to load a Text file to a table through SSIS. Usually, the decimal column in text file would have say "+23456789" or "-23456789". Presently, the file has "+--------"...

Have confusion in schema/user for a long time;

I am going to Create a new schema:

General tab:Test (specify Test as schema owner)

Permissions: search and select the User (...

Its ok if the user can delete his own tables, But other than the using trigger is there no way to stop the user from dropping other's tables?

I am having 2 sets of users. One set(say A) should have only read-access to all the tables in a db. The other set (say B) should have permissions to...

To create tables, I can give ddl_admin access (DB role) to the user. But, then he would have full access to those tables for which he should have only read...

I had created an index the time column.. but since the query took long time to complete, i dropped that index...

As mentioned the Exec plan shows 100% table scan

33 columns and aboutn 250,000 rows.

Execution plan shows Table Scan as 100%. Let me know if any more info is needed

select * from table_name where [time] between

'2009/6/1 6:00am' and '2009/6/30'

no indexes,triggers etc. Field [time] has datatype datetime.

yes saw where to give that file size and rollover. thanks. But when observing the trace using the ::fn.... I see that a single SPID gets repeated more than 200...