Viewing 15 posts - 76 through 90 (of 184 total)
This is an interesting read on permissions:
http://www.simple-talk.com/sql/database-administration/sql-server-security-cribsheet/
September 20, 2011 at 3:33 am
I experienced something similar on a legacy database.
I added the username to the db_denydatawriter role...
USE [EachOfYourDatabases]
GO
EXEC sp_addrolemember N'db_denydatawriter', N'loginnamegoeshere'
GO
It turned out the [NT\Loginname] was part of an AD group with...
September 20, 2011 at 3:29 am
You can choose to break on a custom expression; in your case =Fields!YourClient.Value & Fields!YourCustomer.Value
in the Group On property.
September 20, 2011 at 2:29 am
hunt (9/19/2011)
I am not asking why my insert was falied ...am asking why SQL server accepts such a conflicting range of...
September 19, 2011 at 4:00 am
gsc_dba (9/19/2011)
The constraint has been defined - the values entered conflict with your constraintsSQL has done exactly what you defined...:w00t:
A stored procedure could be written to drop constraints to...
September 19, 2011 at 2:52 am
The constraint has been defined - the values entered conflict with your constraints
SQL has done exactly what you defined...:w00t:
September 19, 2011 at 2:32 am
Congratulations - well deserved. Always learn something new when reading your articles. 🙂
September 15, 2011 at 4:05 am
waseem.shahzad 45937 (9/14/2011)
Thank you all for your wonderful replies."RedGate Software" is Liscenced.
Any open Source TOOL?
September 14, 2011 at 10:15 am
Gianluca Sartori (9/14/2011)
gsc_dba (9/14/2011)
Depending on the script you wish to run, you could try:
sp_msforeachdb
There are limitations and caveats for sp_msforeachdb to be wary of though...http://www.sqlservercentral.com/Forums/Topic438415-266-1.aspx
Nice...
September 14, 2011 at 10:01 am
sjimmo (9/14/2011)
I use MultiScript from RedGate Software. It works great. I use it to run against multiple databases as well as against muiltiple servers.
+1 - I also advocate this tool...
September 14, 2011 at 9:47 am
With reference to the subject line:
How to write a sql query for select statment when number of columns changing dynamically
Try this:
SELECT
QUOTENAME(C.[name])
--, *
FROM
...
September 14, 2011 at 9:15 am
mcushing (7/12/2011)
but it changes based on which facility I've chosen because of the order of the data in the query. Some facilities don't have certain buckets, so it either...
July 26, 2011 at 5:48 am
Right clicking on the chart and choose "Change chart type..."
This will display the current chart type in a dialogue box
July 26, 2011 at 5:35 am
July 26, 2011 at 5:30 am
For what its worth (!) - my advice would be to persevere with trying to get the data you want to be shown in the graph from the SP.
If you...
July 26, 2011 at 5:25 am
Viewing 15 posts - 76 through 90 (of 184 total)