Viewing 15 posts - 76 through 90 (of 91 total)
Woohoo! That fixed it.
Thanks very much for your help.
March 20, 2007 at 4:39 pm
Interesting...
Running sp_helpdb for each database shows the owner is sa for each DB.
The sysxlogins table shows sa with sid 0x01. The dbo users in both Database B and Database...
March 20, 2007 at 4:11 pm
Sorry for the complexity, but here's what I did:
1. Set chaining on all three databases before the reattach
2. Reattached the db as sa
3. Checked chaining on all three dbs and...
March 19, 2007 at 11:38 pm
Perhaps you could use a subreport which displays individuals with a total number of services < X?
March 19, 2007 at 5:37 pm
Look at this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=351344
March 19, 2007 at 5:35 pm
I'd like to know if this is possible too. I have a suspiscion someone will say you need a data driven subscription, which is only available in SQL Ent...
March 19, 2007 at 5:32 pm
I don't have server-wide Cross DB Ownership enabled. I've since enabled it on the three databases in question (it wasn't enabled previously). Database A was owned by a...
March 19, 2007 at 5:05 pm
Ah, that looks great, thanks!
Can you see any problems in using this to define aliases to field names? That way I won't need to define them in 18 spots...
March 14, 2007 at 7:17 pm
I had a similar problem when using a CrossJoin, but the data set was much larger. When I changed it to a NonEmptyCrossJoin, the world was at peace.
PDF is...
March 14, 2007 at 12:00 am
That's a shame - I don't have SQL Ent. Ed.
Isn't there any other way I can do it?
March 5, 2007 at 2:33 pm
Ah yes...
If you have SQL 2000, you need a separate Visual Studio licence. You also need the Microsoft SQL Reporting Services media, which you must have to have instlled...
February 28, 2007 at 8:29 pm
Re: the machine name, it's probably up to you. Clearly your organisation is using DNS. This gives you the advantage of being able to change which server holds...
February 28, 2007 at 5:37 pm
Here's some suggestions:
- You'll need a good knowledge of the Microsoft CRM database structure, so you can create/use its tables, views and procedures.
- You'll need to create an OLE/DB or...
February 28, 2007 at 5:31 pm
I can't say I've run into this problem before, but can you not create the subquery in SQL Server itself (as a view or stored procedure) then SELECT the view...
February 28, 2007 at 5:22 pm
Out of curiousity, is there a performance impact in doing this?
February 13, 2007 at 6:26 pm
Viewing 15 posts - 76 through 90 (of 91 total)