Viewing 15 posts - 8,176 through 8,190 (of 9,725 total)
SWITCH? Is this something available in SQL 2005?
I don't see it in BOL.
December 17, 2009 at 9:15 am
The only tools I'm aware of compare Folders to Folders and Databases to Databases, not Databases to Folders.
The best thing you can do is set up dual monitors on your...
December 17, 2009 at 8:58 am
Have you checked the actual hard drive space? Locate not only your user db files, but the tempDB files. If tempDB is full, it can also cause this error.
AFA the...
December 17, 2009 at 8:56 am
Ditto to the T-SQL script creation. Easiest and quickest way.
You could also try to use SSIS's Copy Database tasks. Though it tends to be messy and not create things in...
December 17, 2009 at 8:50 am
Gift,
I have an end user who does what you're describing. But in the end, no matter what numbers he plugs in to come up with his scenarios, he's still basing...
December 8, 2009 at 6:01 am
WHOOHOO!
Found the workaround.
Create a new database called ReportDesign. Give the report writers whatever perms they need on that database.
Give db_datareader and db_denydatawriter on the "source" databases (from which the...
December 8, 2009 at 5:56 am
That link just shows another question. It doesn't actually show what you did for a final solution.
But if you post the final solution in either thread, then reference that solution...
December 8, 2009 at 4:43 am
Julie Breutzmann (12/4/2009)
December 7, 2009 at 5:00 am
Oh, yeah. Steve's line gives me an idea for a whole 'nother story. @=)
December 7, 2009 at 4:54 am
Gift Peddie (12/3/2009)
Your concept of report is what end user tools do not what developers write.
Gift, I'm sorry. I don't understand that sentence at all. Could you rephrase? Because the...
December 4, 2009 at 4:10 am
Gift Peddie (12/3/2009)[hrIf a DBA stops intermediate inserts which are needed in most complex reports the DBA will write the code to create that report because there are reasons why...
December 3, 2009 at 10:27 am
So it's not that Execute perms don't work, but that by the rules you can't use them?
December 3, 2009 at 10:23 am
Could you post some sample code for the resolution so that people who need this in the future can better understand your solution?
December 3, 2009 at 8:58 am
In my experience, the Compliance team (or whatever name the watchdogs have) are not tech people. If a DBA wanted to get away with something, it would be easy to...
December 3, 2009 at 8:51 am
laurav (12/3/2009)
December 3, 2009 at 6:23 am
Viewing 15 posts - 8,176 through 8,190 (of 9,725 total)