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

I know there sites like rent a coder and stuff where people bid/lowball programming services based on the often poorly defined requirements of a post there. If you have a...

If...

doesn't look like it;

if you look at sp_addmessage via sp_helptext sp_addmessage,

you'll see tat besides a boatload of validation, it still calls an internal proc proc a bunch of times for...

take a look at this thread from just a day or two ago:

Windows Group as Login linked to User Login

I posted some examples of some extended stored procedures you...

i may...

quick simple example if you are still using that route:

--build some sample tables

create table raw4 (id int,somedata varchar(30) )

create table raw14(id int,somedata varchar(30) )

create table raw7 (id int,somedata varchar(30) )

--a...

how is it loading into a grid? DataAdapter.LoadDataTable, then binding the grid to the datatable?

is it using a sql...

instead of multiple tables, why not a single table with your 1-19 etc indicators as a column value in that table? wouldn't that be easier to use and maintain?

why do...

wrap it into a subquery so you can use the aliases assigned to the calculated/grouped items:

SELECT

( [SLAMet] / ( [WO_NUM] * 1.0 ) / 100 ) AS '%TotalMetSLA',

...