I can tell you maximum recursion is not your problem, you are running code in a virtual view which is using many local temp tables SSRS rejects most temp table...

I am not saying Oracle is better than SQL Server but I know it comes with row level security. I enjoy developing in SQL Server but I use Oracle...

In SQL Server 2005 SQL Maint is now part of SSIS(SQL Server Integrated Services) and I think SSIS is not part of the Work Group edition. Check below for...

When the Report Server is separate it is called remote and remote deployment is different your developers need to copy the RDL, images and solution files to your Report Manager...

(Jet, for all of it's issues, is inherently relational and does include DCL.)

Access is an application in Windows so it sometimes uses Windows permission but it cannot be compared to...

The most annoying for 10g to me was 10g overwriting existing 9i connection and Oracle did nothing to fix it. So if you are using 9i in .NET it...

(And I think 9i may be buggy because it was also the first x86 and x64 version of Oracle, I used 9i RC2 as 64bits)

If I said 9i was the...

Your developers need to access the server with reporting services so they can upload the RDL and Solution files and images if your reports used images. Here are the...

The only thing you need from server B where your Datasource Database is the connection string to create your shared datasource.

When the reports are developed you need to give your...

I just read some news that Sun is back to it old Solaris tricks again so MySQL founder quit that is not good. Sun needs the Linux and Windows...

You actually have a better set up that is scalable you just need to make sure you use a shared datasource to make sure all your reports run. You...

I am actually talking about both. The orphaned user were covered in the article I posted in my first reply so adding the restore of the Master was all...

However the user was asking if the logins were restored when a user database is restored which they are not. Login transfer script aside, if there's no backup of master,...

The user have not restored and yes you have hijacked the thread because I have given the user a support article which included the login transfer article which I have...

Yes you are misunderstanding me in 2000 you add the server login in security under management in Enterprise Manager and add the user in the database but not separate security...