I don't think you can tell which group is used and I don't think SQL Server cares. SQL Server just checks does this user have rights to the object(s)...

You can run sp_who or sp_who2 to see if anyone is in the database. Putting in single user mode will work in this case and allow you to drop...

Mohit (11/27/2008)

---

I was considering removing Bulti-In Administrators but wasn't sure if that is a good idea or not. I thought I am just being over jelouse by not wanting...

My personal preference is to use varchar whenever I am not guaranteed a certain length. The examples Gail has given are good example if you are working on a...

I'm not sure exactly what you are asking, but you can use a view within a stored procedure just like you use a table.

Let me chime in by seconding Lynn's opinion. I have worked on databases that have gone with option 2 and that is a fairly difficult design to work with,...

That looks like it is probably a good starting point. What are the columns in each table?

I agree with Phil and Lynn. I started out as a reader/learner and as I read more posts and realized I could help I did. Now I do...

THe procedure is acting exactly as defined. The 10 is a default for the parameter so if the parameter is not passed in it will be assigned the value...

I'd check the version of .NET installed on the 2 machines. I think that might be the issue.

I know I started with MSDN and googled "ReportViewer Control with ASP.NET".

Steven Webster (11/26/2008)

---

I'd certainly agree that a registry hack is not the way forward. Unfortunately though where I work an auditors word is always taken ahead of mine! Interesting point...

Are you wanting to use the ReportViewer control or use an IE control to render reports? Are you doing ASP.NET or a Winforms application?

Based on the error message it doesn't appear that you can. I have never really worked with aliases much so I can't really offer anything beyond that. Now...

I don' personally but I know someone who does a lot with Access UI and SQL Server backend (don't think it's express, but it should still apply) and I'll send...