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/
gsc_dba
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...
gsc_dba
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.
gsc_dba
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...
gsc_dba
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...
gsc_dba
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:
gsc_dba
September 19, 2011 at 2:32 am
Congratulations - well deserved. Always learn something new when reading your articles. 🙂
gsc_dba
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?
http://www.ssmstoolspack.com/Features?f=5
gsc_dba
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_msforeachdbThere are limitations and caveats for sp_msforeachdb to be wary of though...http://www.sqlservercentral.com/Forums/Topic438415-266-1.aspx
Nice...
gsc_dba
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...
gsc_dba
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
...
gsc_dba
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...
gsc_dba
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
gsc_dba
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...
gsc_dba
July 26, 2011 at 5:25 am
Viewing 15 posts - 76 through 90 (of 184 total)