Viewing 15 posts - 46 through 60 (of 152 total)
It is destiny that I ended up where I am today. I don't see any time soon I can live on Social Security, 401K, or IRA. I better keep on...
December 20, 2011 at 12:27 pm
oh, no, you don't want a person that
"Yes, boss, I will do what you told me to do!"
Can you manage that?
December 20, 2011 at 12:11 pm
Here we go again in 2012, double cooked pork. Paul said it will cause fragmentation a long time ago. I said thou should defrag a long time ago.
The title should...
December 20, 2011 at 9:29 am
Paste it into a good text editor, like PFE, where you are going to see unidentified character as '?', Replace them all with replace command.
November 30, 2011 at 10:09 am
Merrill,
Yes, monitoring software like Idera DM and Quest Spotlight does work. I use them all day long. It is the best black-box recorder you can have when CIO wants to...
November 16, 2011 at 7:54 pm
1) This only query current database. I had written a query that inquire all databases. 2) Please remove schema='dbo' whereclause; otherwise you are only getting under schema dbo. 3) This...
November 15, 2011 at 3:02 pm
This stored procedure is deprecated
"sp_change_users_login".
I wrote a query to find all the privilege on the old database, then decide which needs to be implemented on the refreshed dev. It...
November 15, 2011 at 2:55 pm
There is very little to no use for cold backup, either at SQL Server or Oracle world. The only time you might consider for example, is you are already taking...
November 15, 2011 at 2:47 pm
To me the answer should not depend on data type.
C - case
I - Insensitive
A - Accent
S - Sesitive
b and B cannot be Accent differentiated
b and B...
November 15, 2011 at 9:43 am
This audit only deals with someone directly made database connection and made changes, if that was a designated single app login, that has to be recorded by the app. We...
November 15, 2011 at 9:07 am
You should always run Robocopy from the standby host (the secondary) to copy from primary to secondary. This way the Robocopy uses secondary host resources and only reads the backup...
November 11, 2011 at 9:00 am
Robert Davis (10/5/2011)
What if the...
October 13, 2011 at 4:17 pm
If someone took a backup into a folder only s/he knows, you are not going to find it this way. You should query msdb to find backup information.
Regards,
Jason
By...
August 19, 2011 at 3:42 pm
Make sure 1) the network you are sneding from is allowed to relay smtp by "smtp.gmail.com". 2) you have no firewall filtering the port traffic to the destination host/port.
It works...
August 19, 2011 at 1:10 pm
That is a bogus error message I got too. The profile has to be public or the correct principal.
August 9, 2011 at 11:46 am
Viewing 15 posts - 46 through 60 (of 152 total)