my working code for the same functionality is largely the same;

i think you'll need to try-catch and get the inner exception and see what the server/connection issue is;

I just tried...

you can get the date an object is created from sys.objects create_date and modify_date.(tables/procs/views etc)

you cannot get when a permission was granted. that date is not stored anywhere.

if you...

you should post the entire error, especially the error number.

i'll bet this is security related...cant find file or some error like that.

the reason: 'C:\Documents and Settings\ all folders there are...

jdixon-586320 (12/30/2013)

---

First off, I have started doing some testing and have found that if I don't use the user "sa" and password in the connection string on XP it allows...

my version is just an adaptation of Luis's: i'm just selecting the rows form the indexes, as the count is already materialized, and is faster on huge tables.

Thank you Luis...

I'm...

if it works quickly for a while, and then becomes slow, it sounds like out of date statistics might be the first thing to look at.

stale statistics can easily slow...

I've got teh same answer ad Ed Wagner does, i just processed your post through a macro so i had some consumable data.

if you want solid help like that int...

procs and views referencing your tables are only part of the puzzle;

applications can have dependencies on those tables, and applications can reference tables that are never used.

there's a handy chartabout...

info-531323 (12/26/2013)

---

In a stored procedure I dynamically create a temp table by selecting the name of Applications from a regular table. Then I add a date column and add the...

INSERT INTO NewTable(name,mobile)

SELECT name,mobile from a UNION ALL

SELECT name,mobile from b UNION ALL

SELECT name,mobile from c UNION ALL

SELECT name,mobile from d

here's the data you posted, but cleaned up and in a ready to use format:

the column names in your query did not match the data, and there was no easy...

MohamedDBA (12/25/2013)

---

But the compatibility level of the database is - SQL Server 2008 (100) , and this database was created on SQL Server 2008 before I attach It to SQL...

the more updated views under the sys schema, instead of the old dbo.sys* views are recommended instead.

the view below has both a create_date and modify_date that can help in your...

does joining the table against it self help you visualize the issue?

this lets us see how some of the items are related to each other:

--join the table against itself looking...