Viewing 15 posts - 5,386 through 5,400 (of 7,164 total)
For future reference:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 10:49 pm
I would try the identity column method you mentioned...but use a table variable instead of a traditional temp table. I did some quick testing and inserting 400,000 rows into the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 10:12 pm
Ahh...you posted in a SQL 2008 forum and I completely breezed by the first line of your post and went straight to your sample data and the later statements in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 9:57 pm
Jason provided a good lead mentioning Ownership Chaining. Cross-database calls will break an Ownership Chain unless a non-default configuration is put into place. Are these cross-database calls?
Chains can be...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 7:13 pm
Disclaimer: I do not have your tables on my side so this is untested code.
If this code does not work for you right off the bat then hopefully it will...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 6:51 pm
SELECT customerID,
fullname,
phone,
ROW_NUMBER() OVER ( ORDER...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 6:35 pm
This PowerShell snippet could be easily modified to start with a list of server names and provide a list of named instances you can then move forward with checking:
http://www.sqlservercentral.com/Forums/FindPost1100455.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 6:33 pm
allamiro (7/20/2011)
What if I want to change the size limits of the file to 50 MB for example is it also a default can not be changed ?
I do not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 4:20 pm
NBD4K27 (9/6/2007)
That was what I originally thought; however,I saw one of our servers had some trace files in the defualt location and thenInoticed one trace file in a different location...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 4:12 pm
A good rule of thumb is to only grant user access to objects via Database Roles. It makes security management and auditing simpler in the long run and is not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 11:41 am
Jeff Moden (7/22/2011)
ALZDBA (7/22/2011)[hrOf course there is nothing wrong with yea good old DOS ..... in a sqlagent job please.
Not in the in-transaction-code !
I have to disagree there. ...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 7:16 am
ALZDBA (7/22/2011)
You know I'm on my powershell learning curve, so that's what came out of my sleeves :hehe:
Granted, the OP could get the job done with CmdShell using COPY instead...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 6:58 am
Oracle_91 (7/22/2011)
do we have the event notifications for sql 2008 apart from CDC(change data capture)?
Yes. Event Notifications are there...but as Eddie pointed they do not cover DML events.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 22, 2011 at 6:38 am
Jeff Moden (7/21/2011)
...BWAA-HAAA!!!! What's wrong with DOS??? 😛
...
Heh...I'll assume that was a rhetorical question 😛
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 21, 2011 at 9:16 pm
Welcome!
dgossdba (7/20/2011)
1. Will the command just terminate and all statistics that were updated remain that way, and any statistics that were not touched utilize original statistics?
Yes.
2. Will the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 21, 2011 at 4:32 pm
Viewing 15 posts - 5,386 through 5,400 (of 7,164 total)