I changed it to the bottom option and then run:-

EXEC sp_tables_ex 'LinkedServerName'

Msg 7202, Level 11, State 2, Procedure sp_tables_ex, Line 20

Could not find server 'LinkedServerName' in sysservers. Execute sp_addlinkedserver...

Lowell (3/21/2011)

---

diagnose the linked server before using it in your code;

if you run EXEC sp_tables_ex 'LinkedServerName' do you get any results? in theory, it will return all available tables fo...

ANY thoughts?

It takes around...

The order should be :-

1. checking database integrity

2. reorganizing indexes

3. updating stats

But if u r doing rebuild indexes :-

1. checking database integrity.

2. rebuild indexes.

Rebuild indexes updates the stats automatically.

Regards,

Sushant

bitbucket-25253 (3/11/2011)

---

And yet this:

http://msdn.microsoft.com/en-us/library/ms187752.aspx

In SQL Server, based on their storage characteristics, some data types are designated...

select all that apply

and

radio buttons...

LMAO...too funny

I guess its done intentionally...lol

Regards,

Sushant

Ken,

There is other way too and indeed it is more simpler and the fastest way.

Open an excel file->go to data->get external data->from other sources->sql...

Oh k.

Thanks a lot.

Regards,

Sushant

Not related to db , i guess , network speed would be less..

check the network bandwidth...

or try any other large file( non db) and try to copy..

If thts 300 mb,...

I meant the mail body should look like --

No Items Inserted.

IF its possible, otherwise also its fine.

Regards,

Sushant

Now I got the mail body as :-

ITEMNMBR ------------------------------- No items Inserted

Regards,

Sushant

I am calling that procedure in this procedure...

EXEC msdb.dbo.sp_send_dbmail

@profile_name='Sushant Yadav',

@recipients='syadav@xyz.com',

@subject = 'Insert Kit Components',

...

GSquared (3/9/2011)

---

First, Inserts don't work that way, with procedural code between the Insert statement and the data to be inserted (the Select statement in this case).

Second, "output" doesn't work that...

ChazMan (3/9/2011)

---

couple of items:

1) The insert statement is incomplete....what are you trying to insert?

2) What is IF output inserted.ITEMNMBR ='NULL' ??

3) Is the field ITEMNMBR a null...