Viewing 15 posts - 4,996 through 5,010 (of 14,953 total)
You could set up a DDL trigger that tracks the Alter Login event, and logs any change in the password. Then you could query that log table.
February 14, 2011 at 7:19 am
The best option I can think of is output to a temp table, including the $action value (Output clause option). Then insert from the temp table into the archive...
February 11, 2011 at 12:20 pm
I don't know if there's a direct way to handle that.
What do you do with the parameter value in the function? There might be a workaround.
February 11, 2011 at 12:12 pm
young.lee (2/11/2011)
February 11, 2011 at 12:03 pm
Yeah, if it works when you run it, and not when the service account runs it, it's definitely a permissions issue. Do you have a domain admin you can...
February 11, 2011 at 10:59 am
That's pretty much what sparse columns were designed for. Should work out well. Or at least better than EAV or XML.
February 11, 2011 at 10:57 am
Please don't double-post in multiple forums on the same site.
February 11, 2011 at 10:34 am
If it's the other way around, you can run into truncation problems when a parameter is larger than its target column. This way, with the parameter smaller, it won't...
February 11, 2011 at 10:33 am
In SSMS, does the query insert into the same target?
I've seen SSIS have problems like what you're describing, because of different datatypes in the target than in the source. ...
February 11, 2011 at 10:31 am
Are all of those tables defining essentially the same thing? Like all are different versions of name-and-address data, or something like that? Or do they define different things,...
February 11, 2011 at 10:29 am
Two possibilities I can think of here:
Check permissions at both ends. You might have full permissions on the source, but not on the destination, or vice versa. Seems...
February 11, 2011 at 9:28 am
What you're doing is essentially a "mutex". I've done pretty much the same thing for several jobs in several shops, and it has worked out just fine for me.
Look...
February 11, 2011 at 9:13 am
There was a discussion on parsing XML with two namespaces on this forum just last week. Try searching for that, see if it gives you what you need.
If not,...
February 11, 2011 at 9:11 am
I don't know of a tool that will do that automatically. I would be kind of surprised if there is one.
February 11, 2011 at 9:08 am
I've been saying for years that the job of a DBA is to make his own work as boring as possible.
I use SSC to stay sharp and interested.
There are issues...
February 11, 2011 at 8:58 am
Viewing 15 posts - 4,996 through 5,010 (of 14,953 total)