Viewing 15 posts - 9,316 through 9,330 (of 9,715 total)
Have you tried adding a calculated column to your temp table?
Alter Table #MyTemp
Add MyCalcCol AS (Col1 * Col2)
Or something like that. Where the "datatype" isn't actually a...
November 9, 2007 at 6:22 am
I don't know if there is such a thing as a SQL Only person anymore. Especially with MS putting out SQL Server editions that require VB .Net and C#...
November 9, 2007 at 6:19 am
I'm still not making much progress myself. What's the Schema_ID and principal_ID of the proc in sys.objects? Also, have you tried scripting out the server & database configs...
November 9, 2007 at 3:54 am
Jason,
This is going to sound odd, but ... Have you checked your permissions (and inherited permissions, like group memberships) on this server? Verify schema defaults and see if there...
November 8, 2007 at 8:39 am
I don't know, but it doesn't hurt to check and see if there is a difference. @=)
I'm going to do some playing around and see if I can replicate what's...
November 8, 2007 at 8:02 am
I take it you're creating these with the CREATE PROCEDURE statement instead of using a template or right-clicking the Stored Procedure folder and choosing new?
November 8, 2007 at 7:55 am
You never said what your job title is or what the job description is, so your comment about "proving yourself as a good DBA" is a little vague.
Post...
November 8, 2007 at 7:17 am
Jason,
You've got me curious now. How are you seeing it marked as a system stored procedure? In what screen or from what query?
November 8, 2007 at 6:31 am
The second part of your last post is pretty much what I found in my study book, but it didn't have any accompanying definitions, which is what confused me. ...
November 2, 2007 at 10:35 am
Okay, now there's something I didn't consider at all. Because if you had to restore, you would have to restore every single last transaction log that goes along with...
November 2, 2007 at 10:12 am
I'm betting it'll be fixed on Sunday. @=) That's when DST ends here in the States.
Of course, the site could be bugging a bit on its DST...
November 2, 2007 at 5:53 am
That's pretty much what I thought, but then I've missed obvious points from these book examples before, so I figured I'd double check.
Thanks everyone for your comments. I really...
November 2, 2007 at 5:20 am
On the other hand, you really have to appreciate an author with a great sense of humor and a strong grasp of reality. Just got to the restore portion...
November 1, 2007 at 10:49 am
Pam,
Thank you so much for your reply. That's MUCH better than the explanation of latches I have at hand and once I read what you posted, I actually understood...
November 1, 2007 at 10:33 am
The only option I can think of is to do a bunch of LEFT OUTER JOINS to db1.sys.objects, db2.sys.objects, etc.
November 1, 2007 at 10:26 am
Viewing 15 posts - 9,316 through 9,330 (of 9,715 total)