Now,

We are planning to install SQL Server 2008 standard edition on Server1(Which has SQL Server 2000 right now) and keep server2 as it is (SQL Server 2005 Enterprise Edition).

Will there...

Using Integrated Windows Authentication by putting users in groups and giving the groups access to roles on the SSRS and similar have been best practices for maintenance and security for...

In general what I'd suggest is you set up some local or Active Directory Groups, assign the groups to roles on your Report server and then add the individual users...

MeltonDBA (4/2/2010)

---

I don't type that fast so Perry beat me to it...

But to re-iterate:

You...

darth.pathos (4/2/2010)

---

OK, so i have copied the DVD files to my C:\. Here's what I see:

C:\SQL\ia64, \x64, and \x86. I also have autorun.inf, setup.exe, and a couple of...

Bru,

If you cannot use a dataset then you may have to use SQL Server Agent in another server try running it when the Agent is idle because when we ran...

james.arceri (4/1/2010)

---

Hello readers,

I am starting a new web based application using C# (ASP.NET), and have been looking at the data model that is given to us by our friends at...

Bru Medishetty (4/2/2010)

---

Hi thanks again for that.

I am using OLE DB Destination and I do not have table or fast load option for data access mode. The property you mentioned...

Copy the content of the DVD to your c drive and run setup in the tools folder that will install all the client tools which includes Management studio.

The above is your problem you are trying to attach a SQL Server 2000 database as a User Instance that is invalid because 2000...

steve block (4/2/2010)

---

There were no Windows updates for Sql Server. I did re-install SS 2000 Standard Client Tools, just Enterprise Manager, and that seems to have take care of...

steve block (4/2/2010)

---

I had looked at that article and I didn't see how it applied. I am not trying to edit it in 2005 (or 2008). I have...

I think most...

When the JPEG is in the database I think you need to put it in a rectangle to use it in a report, so if you are getting red x...

ucbus 92278 (4/1/2010)

---

I have a vb.net application that calls a stored procedure to get the data. The stored procedure is a select statement with bunch of sub-queries. The procedure has...