rajborntodare is correct;

the information is not saved anywhere on SQL server, unless you explicitly added one of the many audit options available to SQL server.

so going forward, I would recommend...

wow amazing what a little coffee can do for me!

my issue was the wrong tool for the job.

i needed to use DENSE_RANK() and not ROW_NUMBER

this is what i should have...

arooj300 (6/13/2013)

---

Hi,

I have a 4 GB CSV file , which i am unable to import in SQL Server 2008 R2, even I not able to open file also. I tried...

SSMS = SQL Server Management Studio, sorry about the acronym!

here's two ways how i might do it.

first create yourself a temp table to capture the results from the code below:

the code below is doing TWO examples,

one to build...

prtk.raval (6/7/2013)

---

I am just wondering about the the tables as they are located as following structre in SQL SERVER MANAGMENT STUDIO

SERVER OBJECT => LINKED SERVER => [ORACLE LS] => [CATALOG]...

vs.satheesh (6/7/2013)

---

i am using CTE in following ways

with CTE1

(

select * from xx

),

CTE2

(

select * from xx a inner join CTE1 CT on xx.id=CT.id

) ,

CTE3

(

select *...

it's incredsibly similar; you just have to use the four part naming convention:

SELECT

TABLE_NAME,

COLUMN_NAME

FROM

MyOracleLinkedServer...ALL_TAB_COLUMNS

WHERE

COLUMN_NAME LIKE '%PATTERN%';

if you are not a sysadmin on the linked server, you might have to use USER_TAB_COLUMNS...

not sure which of the two tables are the problem, but i'd start by looking at any values that cannot convert to a numeric datatype:

SELECT * from [dbo].[Final] ...

whether is was near simultaneous or five minutes apart, what prevents two people form overwriting the task at all?

does the business /app portion present a list of available task slots...

it's going to look a lot like this:

the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example did...

Sean Lange (6/6/2013)

---

I for one would be super interested in seeing how you reverse engineer your indexes. I just went through this process and I have a feeling yours will...

here's a start to finish example, where i create a user, grant just the permissions Perry identified in his posts, specifically impersonate that user for testing, and then read from...

Sean mine was just a lazy adaptation of something that already existed; it was easier than from- scratch script to find them; this adapted snippet from the middle of your...

bslchennai (6/6/2013)

---

Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns. and now my database size is...