suser_id()

suser_name()

functions are what you are looking for i think ?

if not you may need to be more specific

Point taken.

as i started out with... monday morning 🙂

ok.. but that kind of defeats the propose where you want to work with the current row in the select part insert statement.

That is for each line in the...

you will need to have execute rights to the sp_addlinkedserver procedure.

that's correct.. server side cursors are not something you want to do . I have been scaling them out.

like adam said post the schema and what is needed. im...

well first of if writing a cursor doit like this.

declare @databasename sysname

declare myCursor cursor for

select name from sys.databases

open myCursor

fetch next from myCursor into @databasename

--let's start looping

while @@fetch_status =...

Did you let the installer configure SSRS ?

if so i would try to create an new SSRS database from within the SSRS configuration tool.

I have had some problems with SSRS...

What was interesting to me was that I tried to telnet port 135 between the 2 computers after enabling inbound and outbound MDTC. but all was good after I opened...

hi.. i have spent my whole day trying to resolve this issue. now from what i have seen.. the DTC does not like triggers not sure if that is actually...

well. you use the unpivot temp table to join to the source table on primary key columns. then you get your data.

if you are changing values in the pivoit table...

well basicly what you would have to do is unpivot the data. update the source table with the normalized data.

example from BOL

CREATE TABLE #pvt (VendorID int, Emp1 int, Emp2 int,

Emp3...

I would try to solve this by removing the subquery , creating an CTE with the aboce stuff . and selecting and filtering the CTE.

With myCTE as

(

SELECT P.street_number_full AS StreetNumber,...

yes it's far from a perfect solution, but i would check out the new triggers browsed them a little and they look good.

Hi.

I am facing the same problems as you have been describing. Now what I Did was to create a database with a "user audit"

table DB_Usage(db_id int , active_dttm datetime)

now then...

sorry... incorrect code.

with mysession(date, session) as

(

select date, session from #rr where message <> 'error'

)

select top 1 convert(varchar,date,2),session from mysession

group by convert(varchar,date,2),session

having count(session) = 3