Viewing 15 posts - 526 through 540 (of 588 total)
AD time issue should only be an issue if you use Kerberos though. Or at least so I have been led to believe.
But then I am not an infrastructure person...
March 14, 2007 at 2:33 pm
I'd assume that is comming from the CPU slowing down or speeding up to save energy.
March 13, 2007 at 3:07 pm
I had to look up domain data while extracting data out of an XML column. Did something like this:
from TableA...
March 13, 2007 at 12:48 pm
Well looks like someone had been tinkering with security. The server and the agent are running under two different accounts, this was supposed to have been changed 2 weeks ago,...
March 13, 2007 at 11:59 am
I use the following when I use cursors, see if that helps.
FETCH
NEXT
March 13, 2007 at 9:25 am
I would think this would be impossible to answer from a data loss or strange side effects without knowing the entire process that the server is used for. My gut...
March 13, 2007 at 8:32 am
Post in a forum for TSQL on SQL 2005 you will get a SQL 2005 answer.
Both solutions given will give the result set you asked for in the initial post,...
March 13, 2007 at 8:10 am
Execute As might work, not sure you can have a user impersonate DBO though. It is fairly well documented in Books Online under impersonation.
March 12, 2007 at 12:47 pm
Something like this?:
create
table #t (
C1 nvarchar(
30))
March 12, 2007 at 11:55 am
If it is set up as an identity then it should never be re-used, unless DBCC Checkident is run against the table with reseed option set.
March 12, 2007 at 11:33 am
So I found two solutions, well I found one that is not so good, then one of my co workers showed me what is most likely the correct way.....
My solution:
March 9, 2007 at 6:46 am
Check into using Except maybe? Check books online under Except Operator.
March 8, 2007 at 10:33 am
I can't remember in 12 years of being a DBA having once defragged the hard drive on the disk with SQL databases on it.
I know at a previous job...
March 8, 2007 at 10:24 am
Should be able to use a DDL trigger. Straight from BOL, you would have to come up with a schema for notificatino, but should not be too hard to add...
March 6, 2007 at 10:35 am
Viewing 15 posts - 526 through 540 (of 588 total)