mail.baberkhan (2/28/2012)

---

BULKADMIN

BULK INSERT administrators. Can load data into tables using BULK INSERT statement.

Database administrators responsible only for loading data through BULK INSERT. Data import specialists.

So With Bulk Admin rights...

wierd; how is the data being inserted into the out_dialler_calllist...

if you declare a varchar/char/nvarchar with out a size, it is a single character.

only in a cast/convert is it 30 chars without the size declaration.

declare @var varchar

declare @var2 varchar(50)

besides that,...

the unexpected results is just what Alexander is experiencing; but this is technically a known behavior.

his expectation...

ok , so if it's async, i'm assuming the data values have been inserted or updated to some table, and then the service broker is getting called....in a trigger,...

andrew do any of these DMV's help you get the iinfo you are looking for?

select * from sys.sql_expression_dependencies --(2008 +)

select object_name(id) as MyObject,object_name(depid) as ReferencedObject,* from sys.sysdepends ...

kramaswamy (2/27/2012)

---

Hi all,

Got a situation which I'll simplify into the following question. Let's say I have this block of code:

CREATE TABLE TestTable (ID INT, Val VARCHAR(20))

BEGIN TRANSACTION

INSERT INTO TestTable (ID,...

If you had massive amounts of data like L' Eomot Inversé 's example, I'd think that using .NET or ADO to bulk insert would be the solution;

accumulate the data locally...

backup and restore are the best solution i think.

it will copy all objects perfectly that exist inside the database...that' distinctino is important, because you asked about:

will to copy all db...

adding the login is not enough...did you add them to the server role as well;

something like this is what you are after, i think:

--Add/Restore Restore Builtin\Administrators

EXEC sp_grantlogin 'BUILTIN\Administrators'

EXEC sp_addsrvrolemember...

your trigger will only handle one row; so if the applicaiton inserts or updates multiple rows, you will not get all teh changes.

something like this is probably pretty close to...

there we go;

a see a few things that can help improve perforamnce;

first, it's designed to be a catch all query;

read Gails article on the performance issues here:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

i see there's...

Jeff Moden (2/25/2012)

---

Actually, there's a valid reason for doing such a thing as what the OP wants to do. It makes maintaining indexes much easier and quicker and it...

the code might be the same, but the execution plan is not.

that's the definitive way to review it...get the execution plan from each server, and compare them. post them here...

SQL_Surfer (2/25/2012)

---

Another clue. SP makes use of a table variable. Does changing it to temp table will help? The same sp on another server returns data to the app within...