Viewing 15 posts - 61 through 75 (of 148 total)
jts_2003 (2/8/2012)
Daniel Bowlin (2/8/2012)
I had to do a little research. I definitely learned something useful. ThanksSame here, so good question. Thanks.
+1 Still no sure to understand it...
February 8, 2012 at 6:20 pm
The question is "Can a non persisted computed column reference column(s) that are NOT in the same table as the computed column.? "
http://msdn.microsoft.com/en-us/library/ms191250.aspx says "A computed column is...
January 31, 2012 at 7:24 pm
Ten years ago, we had that "contractor" specialized to help "troubled" company and who had this neet idea that employees should evaluate (anonymously) their co-workers and their boss once a...
January 30, 2012 at 6:16 pm
Neet! I like the idea about the CurrRec column
But your "scenario" would not work for us.
Different need, different solution!
That is what I like: nothing "repetitive",...
January 26, 2012 at 5:21 pm
It would cost nothing to change the question to add the edition would not it?
Steve, could you please change the question for "on your SQL Server Enterprise 2008 R2 ...
January 26, 2012 at 5:53 am
bitbucket-25253 (1/23/2012)
tilew-948340 (1/23/2012)
The question was 'on your SQL Server 2008...
January 24, 2012 at 4:06 pm
I desagree with every one because Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.
The question was 'on your SQL Server 2008 R2 databases.'...
January 23, 2012 at 6:28 pm
vikingDBA (1/23/2012)
GRANT UPDATE ON SCHEMA Production
...
I prefer to set up roles, and grant the specific permissions needed to them, and then assign whatever users to...
January 23, 2012 at 5:52 pm
No, I am not doing shema wide permission, I am doing role that gives schema permission.
The command in my "QueryFile" would be something like
GRANT...
January 23, 2012 at 5:34 pm
Richard Warr (1/20/2012)
Hugo Kornelis (1/20/2012)
Just for kicks, I decided to do the math. ....................Thanks, best post I've seen all week. I love stuff like that. 🙂
+1
I hope you had as...
January 20, 2012 at 5:18 pm
vikingDBA (1/20/2012)
January 20, 2012 at 5:01 pm
vikingDBA (1/19/2012)
Don't know if this will help, but see this link for a script I wrote ... Hope this helps.http://www.sqlservercentral.com/Forums/Topic1226870-359-1.aspx#bm1230153
Neet and huge program! I hope I'll...
January 19, 2012 at 5:38 pm
SQLRNNR (1/17/2012)
Try this script
WOW! That is impressive! I had no idea I could do that!
But, sorry... it is still not what I was looking for... (but it is...
January 18, 2012 at 8:14 pm
Wait! it does not works fine for the table either.
I think the best way to do what I want is to forget about the GUI and the copy and...
January 17, 2012 at 8:23 pm
SQLRNNR (1/17/2012)
Shawn Melton (1/17/2012)
January 17, 2012 at 8:10 pm
Viewing 15 posts - 61 through 75 (of 148 total)