Viewing 15 posts - 6,346 through 6,360 (of 7,164 total)
amns (5/24/2011)
I've some tables with varchar data type in some columns.
This tables store static values, so i need to generate scripts for create table and table data.
I generate the scripts,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 1:25 pm
How can i capture the user name who used this sql account to connect to the sql server when they have to actually connect only using application, I would also...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 12:33 pm
If I turn snapshot isolation on and find performance is adversely affected, do you think I can simply turn it back off to undo the damage?
You can turn it on...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 12:25 pm
Please post your trigger code.
Do you have Database Mail ready and able to send emails from your database instance?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 10:30 am
The best you can do is lookup the login's default database but there is no guarantee that the connection string did not provide an alternate/explicit database name to begin in.
I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 10:13 am
jcrawf02 (5/24/2011)
opc.three (5/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 9:30 am
Grant Fritchey (5/23/2011)
opc.three (5/23/2011)
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 9:21 am
Not sure about "best practice", sounds like someone tossed in a buzz phrase to justify some action. Management is far enough away from the details to not know the particulars...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 9:04 am
Because nolock has been deprecated, though, my bosses want me to use snapshot isolation instead.
The NOLOCK hint has not been deprecated on SELECT statements, only with the use of UPDATE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 7:38 am
Sure thing jcrawf02. As a side note, I would not have posted at all because the poster would have caught the IN/NOT IN logic nugget, however when there is a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 7:10 am
Duplicate post...direct replies to this post since OP confirmed they are on 2005:
http://www.sqlservercentral.com/Forums/Topic1113770-149-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 5:27 am
In the 2005 link Koen posted it says:
If the /ConfigFile option specifies a location for the configuration file that is different than the location that the package specifies, the dtexec...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 5:22 am
Thanks for the nod Yin :Wow:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 8:59 pm
...same results but a little more concise:
SELECT INDACCOUNTNUMBER ,
TOTALPYMTAMT ,
NETPAID ,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 8:29 pm
It's all about the parentheses...try it this way:
SELECT INDACCOUNTNUMBER ,
TOTALPYMTAMT ,
NETPAID ,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 8:27 pm
Viewing 15 posts - 6,346 through 6,360 (of 7,164 total)