SELECT i.name, o.create_date

FROM sys.objects O INNER JOIN sys.indexes I

ON o.object_id = i.object_id

WHERE OBJECT_NAME(o.object_id) = 'TableName'

Should you not be telling us what you'd expect to see?

😛

Forgot to mention, once you have added the login back in, if you try to add the user, you'll likely get a message telling you the user already exists in...

Sure, if you only have a few logins / databases etc in the master database, then yes, you can attach your client database and quickly add the logins back in...

Also, if you are connecting from a desktop where you only have client tools installed, you won't see the Reports menu

Do you have reporting services installed?

You can run a profiler trace and include the hostname in that trace.

Hi,

The only one I have seen in use is Spotlight from Quest - they gave me a demo. It's a usefull tool.

You mentioned "system files". I'm not sure if you meant SQL binaries or system databases?

If you meant your system databases were also on C then you'll need to recreate...

Profiling the database would also be a good idea - get an general idea of performance. Cross reference this when speaking to the clients to allow you to formalize...

It's a catch-22 situation. I was interested in the finance world, but like you, all of the jobs would require a decent knowledge of finance. To be honest,...

BI Documenter is also a pretty good tool. Creates a compiled HTML file.

We use this to distribute schema documentation to clients.

SELECT TOP 1 Manufacturer

FROM CarManufacturer

GROUP BY Manufacturer

ORDER BY COUNT(1) DESC

Steve nailed it.

However, I'm not sure if this would be applicable in your environment, but we had one user who used their login credentials in an excel spreadsheet and this...

Find the document then!! 😉

Seriously though, Lynn is right - the query should reference the correct schema. Using the sa login will default to the dbo schema. I...