Viewing 15 posts - 4,801 through 4,815 (of 9,643 total)
Matt Miller (7/6/2009)
Just think how much he's hating us for having to register each and every single time to see these answers.....:)
That's reason enough for me to add a post...
July 6, 2009 at 1:49 pm
Well, in reality, you probably don't want to give SA access within a stored procedure, but you can use EXECUTE AS to change security context
July 6, 2009 at 1:43 pm
Nope, no FINALLY in SQL Server at this time. http://technet.microsoft.com/en-us/library/ms175976.aspx
July 6, 2009 at 1:41 pm
Can you post the settings you have for the linked server? How have you setup login mapping?
July 6, 2009 at 9:19 am
Can anyone with some Service Broker knowledge help out on this one
July 6, 2009 at 9:13 am
A SID is a GUID that AD uses to uniquely identify an account (they are also used in SQL Server for SQL Accounts). When you assign an account to...
July 6, 2009 at 9:03 am
I'd agree with Jeff on this one. If I were to be working on certification I'd go with 2008.
July 6, 2009 at 8:47 am
The Optimizer uses statistics to determine if a seek or a scan is the likely "best" access method for a given query. It actually takes a very small percentage...
July 6, 2009 at 8:46 am
Did you uses Surface Area Configuration to re-assign the account to the SQLServerAgent Service? It sounds like you have mismatched SID's which is why you are getting unknown. ...
July 6, 2009 at 8:41 am
I have to ask, what kind of application do you have where the users are running DDL statements? This is not a typical situation, at least not in my...
July 6, 2009 at 8:37 am
There are 2 ways to return a single value from a stored procedure, as a resultset and as an output parameter and the recommended method would to use an output...
July 6, 2009 at 8:31 am
Is the Ray-PC\Ray account an administrator on the PC?
July 6, 2009 at 8:24 am
Have you identified what type of component is causing the error? This would help others help you determine the issue.
July 4, 2009 at 8:46 am
Have you double-checked that the email address is correct? Have you looked in the inbox for the SQL Server account to see if you got a system undeliverable message...
July 4, 2009 at 8:35 am
Just be aware that the solution you have selected will not scale well as it can at best do a index scan because of the function being used on the...
July 3, 2009 at 2:29 pm
Viewing 15 posts - 4,801 through 4,815 (of 9,643 total)