anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of...

You are getting confused here about security context. When you log into SQL Server as "sa", SQL Server is a self-contained system. It has no knowledge, or even rights, to...

Not sure. I think there is a difference depending on your security connection and setup (AD v non-AD, group v...

Sorry, I think I typed too many S's. Old habit from tracking machines too often.

suser_name() should return the security context.

http://msdn.microsoft.com/en-US/library/ms187934%28v=SQL.90%29.aspx

suser_sname()

http://msdn.microsoft.com/en-US/library/ms174427%28v=SQL.90%29.aspx

Is the file name the same every time? Same location? Or do you need to somehow read what's on the FTP site and then programmatically pick a file to retreive?

That actual rendering of the report is likely the smallest part of the time. As mentioned by the ninja, you need to tune the queries. So focus on tuning those.

If...

I don't usually do this, but...

If you have SQL 2000 installed, you cannot install a default instance of SQL 2005. You would install a named instance, or upgrade your SQL 2000 instance to 2005.

That was a good catch. Looks like I need to write a good one pager on this and include all information

Thanks for the update. Good to have the answer listed here for others.

The "let me google that for you"

You choose where you install each version. The named instance of 2005 will have nothing to do with the 2000 instance you have installed. If you upgrade, it will keep...

Wayne,

Hadn't seen that before, but it's great. I bookmarked it to use it for some question.

Yeah, those dates from Jason sound right. We upgraded from 4.2 to 6.0 to start a dev project, and then about 6 months in 6.5 came out. I don't remember...