Viewing 15 posts - 43,036 through 43,050 (of 49,571 total)
Where? When setting up the distributor? When setting up the publication? When setting up the subscription? There are a number of places where security gets set doing replication.
Generally the SQL...
November 22, 2008 at 11:23 am
rbarryyoung (11/22/2008)
You were there too? Rats! If I had know that I would have tried to find you...
Jonathan was the one who commented about Linq.
November 22, 2008 at 11:19 am
What settings where do you not understand? When setting up the distributor? The publication? The subscription?
November 22, 2008 at 12:48 am
Phil, you say
I include DBCC Log, and its offspring fn_dblog, where there seems to be no documented way of doing perfectly legitimate actions to maintain or audit your own data.
You...
November 22, 2008 at 12:41 am
If you don't already have some form of auditing in place, there's no way you're going to identify historical events. If you're setting up auditing, then you can use the...
November 22, 2008 at 12:34 am
Jonathan Kehayias (11/21/2008)
how to write badly performing code which I have always wondered how to do. 😀
😛
Congrats on the award. I intend to take the app for a...
November 22, 2008 at 12:27 am
Lynn Pettis (11/22/2008)
Ahh geez, Gail, you're taking the fun out of it! :P;)
Oh, I'm sorry. I'll play dumb next thread... 😉
11pm Seattle time and I'm checking the forums. still...
November 22, 2008 at 12:25 am
venkat (11/21/2008)
Hi,Do you know I'm a Sr. DBA. Some times I am full bizzi thats why I'm sending forum response for finding easiest and fastest way.
A senior DBA who...
November 22, 2008 at 12:15 am
The transaction log is not there for auditing purposes. If you're wanting to audit data changes, look at triggers. DML triggers to capture data changes, DDL triggers to capture schema...
November 22, 2008 at 12:03 am
I don't have time right now to try and rewrite your entirequery, especially not without table schemas or sample data. Look at the sample update statement I posted above and...
November 21, 2008 at 11:57 pm
Jeff Moden (11/21/2008)
Another favorite are those that ask things like "which would be faster" and they post the code for both... talk about "lazy". :hehe:
Yeah, but at least those are...
November 21, 2008 at 11:56 pm
does that login have a mapped user in that database/
November 21, 2008 at 3:09 pm
The different settings may cause problems. Make the settings in management studio the same as in the app and see what behaviour you get.
November 21, 2008 at 3:09 pm
Don't have time to rewrite it now.
Can you try moving the subquery with the sum into the from clause and treating it as a derived table? I know it's not...
November 21, 2008 at 3:08 pm
There are articles on my blog on parameter sniffing.
Were all the parameter values the same? All the options (ansi_nulls, etc) the same?
November 21, 2008 at 1:58 pm
Viewing 15 posts - 43,036 through 43,050 (of 49,571 total)