-------------------------------------------------------------------
:::: Great Indian Developer Summit 2009 - GIDS .Net ::::
:::: 24 April 2009 ::::
:::: J N Tata Auditorium, IISc, Bangalore ::::
:::: http://www.developersummit.com ::::
-------------------------------------------------------------------
Dear Group members,

The economic downturn will run out of steam trying to outdo the 'ready
and waiting' software professional. Packed with premium knowledge,
action plans and advise from been-there-done-it veterans, creators...

It was after testing with that and not having an issue that I figured
out my problem was really with the objects that were in schemas other
than dbo.

All of the schemas were owned by the user id that created them rather
than being owned by dbo. I changed them to dbo and was able to grant
the permissions needed. I can now see the objects in SSMS without a
problem.

Thank you for your help and for including your script.
Toni

*** Sent via Developersdex http://www.developersdex.com ***

Hello,

We would like to use SQL Mirroring as a high availability option for our
production environment. Our user databases are not a problem. It seems
like SRS might be though. When using mirroring, the principal database
needs to have it's recovery mode set to "full" and from what I understand if
mirroring SRS, we need to mirror the ReportServerDB and the
ReportServerTempDB. The later DB runs in simple mode (since it's tempdb).
When doing SRS as part of H/A I understand that both DBs have to sync
together. Is this doable and if so, can anyone point me in the right
direction? I also am aware of the RSConfig and RSKeyMgmt issues.

We are running SQL 2005 with SRS 2000 (will upgrade to SRS 2005 next year).

Thanks so much,
Steve

I installed a SQL Server 2008 Express today on my local machine, and after a
successful local installation, I tried to connect (from the SQL Server 2008
Management Studio) to an instance of SQL Server 2005 Express on a network
server. It connected successfully but it failed when loading the databases
list (i.e. expanding the Databases node) with error 916, indicating that my
account didn't have permission on the Report Services Temp Database.

I resolved this by logging in with Administrator on the server and adding a
user mapping for all Domain Users to that database, keeping only Public as
permission, so not giving actually any new permissions for the database (my
account is a domain user). After that it loaded fine.

Anyway, other databases seemed to have the exact same configuration as the
temporary database of Reporting Services 2005 but didn't fail like that, so I
don't have an explanation for the issue, just the workaround above. To be
sure that this doesn't happen again I added the same user mapping on all
other databases on the server so that all domain users can browse the
databases themselves without having permission to read/write any tables.

I think this is a bug in the new SQL Server 2008 Management Studio as 2005
Management Studio didn't have this problem.

Are there any plans to release Analysis Server Management Objects 2008 (AMO)
in a separate (free) download?

SMO 2008 is released in a feature pack here - I expected to find AMO there
also but it's not there:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69...

you can get AMO 2005 (here:
http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226...),
so why not AMO 2008?

Jesse

Hi,
I've recently installed the SQL 2008 tools so I can begin creating SSIS 2008
packages. However I've found that I now have an issue with my existing SSIS
2005 packages where I have script tasks. I am not longer able to edit the
script tasks in the 2005 packages.
Has anyone run into this issue and know the fix for it?

Thank you,
Keith

I want to export SQL data using BCP.EXE and for normal operation everything's
fine. The default record delimiter of "\n" gets mapped to 0x0D, 0x0A and
this works for the PC/Windows.

But when I want to export data for a UNIX system, I don't know how to tell
BCP to really just spit out a single line feed (0x0A) and not the CR/LF pair.
I can successfully export for Macintosh by using "-r \r" and only a 0x0D is
emitted.

Yes, I can play tricks like emitting just the CR and then running the output
through a tr-like utility to change the 0x0D characters into 0x0A, but it
sure would be nice to bcp out the data with the right record terminators to
begin with!!

Is there a way to tell bcp.exe *not* to cook the line endings and treat \n
as just a linefeed?!?

Regards,
-- TB

Hi All,

I have Visual Studio Database Edition (Visual Studio 2008, SP1) installed
and I'm trying to create a Data Generation Plan according to these
instructions:

http://msdn.microsoft.com/en-us/library/aa833237.aspx

My problem is that I do not have a Data Generation Plans node in Solution
Explorer. I cannot add a Data Generation Plan. The Data Generation Plan does
not exist.

Does anyone have an idea on how to fix this?

Looking for a tool that I can compare like db's on different servers.
I.E. I want to compare and see differences in the data on our dev
server versus our production servers.
Anyone know of a good one?