well my first guess was off i guess, but i still think it might be permissions.

lets go back to the basics, i guess: you said this:

when i try to access...

inside a trigger, or procedure, there's a lot of built in functions you can use;

I use a variation of this in a lot of auditing type stuff:

--the auditing...

if the user explicitly says SELECT * FROM NEWTABLE, does he get an error stating "object does notexist or does not have access"

if that is true, it sounds like the...

I used Recuva, some free app on http://www.piriform.com/recuva recently to get some stuff from a folder that was deleted on Win7 / 64, it worked, but others may know of...

spids get reused, as they disconnect and someone else reconnects; You might want to add a trace so you can get the data you want int eh future, complete with...

i have tehse saved in my snippets; does this do what you want?

--elapsed time/datediff

select

[Days] ...

here's my first guess; there's a lot of flexibility in ISDATE and convert, you might get dates that are out of range.

;With mySampleData

AS

(

select '1 - Apr' As dt, 2010 AS...

I know you are leaving a lot out to simplify the examples, but that ends up adding more questiosn than answers.

why do you think you need two tables that represent...

but the logon trigger only works if the person doesn't know how to change their connection string to explicitly say an application name:

so the logon trigger is not 100% realiable,...

snomad (1/16/2012)

---

so I guess there are 2 issues:

1. What changed the password (if indeed it changed?) Or what else could have caused this?

There's nothing in...

i'd avoid this at all costs.

functionally, I see you want to put the data into separate ytables because it makes "sense"...you want to compartimentalize the data the way you...

No problem, glad i could help;

If you are coming from a programming background, Functions and Subs are interchangable, and the only difference...

a foreign key can only be created against a column (or group of columns) which are either the Primary Key of the table, or has a Unique Constraint against it.

Based...

niha.736 (1/16/2012)

---

Hi all,

If a table contain no records and if I write the statement as insert in functions and I also written it in the stored procedure, so, what will...

without any auditing already in place, all you can do is prepare for it to happen again in the future.

http://www.ssmstoolspack.com/ has the free SSMS toolpack, and its "SQL History" feature...