Viewing 15 posts - 2,311 through 2,325 (of 6,486 total)
Also keep in mind that depending how big your DB is right now - it will take some time to grow the file up to 120GB. If you're talking...
November 5, 2008 at 3:21 pm
Here's the starting point on this. It ain't pretty, but it never used to be pretty in the old days either....
November 5, 2008 at 3:18 pm
It's not working because you're not enabling impersonation on the IIS web site side. The query is being passed under the credentials of the IIS server service, unless you...
November 5, 2008 at 2:20 pm
Andrew Peterson (11/5/2008)
here is a good example, and btw, this function is very useful. It converts strings to a table
Andrew -
A loop is a rather slow way to...
November 5, 2008 at 2:09 pm
Andrew Peterson (11/5/2008)
November 5, 2008 at 2:05 pm
hodgy (11/5/2008)
have a look a this script for a generic audit trigger:http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
perhaps this addresses your issue?
Tom
Which will go "BOOM" against any of the "uglier" column types (TEXT/NTEXT, or any of...
November 5, 2008 at 10:38 am
It's perhaps best to start by simply "cullling the herd" (i.e try to instantiate this into an XML reader object, and see which ones bounce out.) Once you get...
November 4, 2008 at 7:53 pm
jcrawf02 (11/4/2008)
Grant Fritchey (11/3/2008)Sometimes a programming language lets you do something confusing or counter-productive, but that doesn't mean you should.
dang, there goes my whole philosophy of programming . . .
I...
November 4, 2008 at 9:23 am
Actually - I didn't describe it well. If you look at the 4th column there you will see the replacement styles. The one slated for deprecation is one...
November 4, 2008 at 9:19 am
It's not a dumb question at all. It's more of a VHS vs BetaMAX deal though (they happen to have dervied from distinct products not set up to talk...
November 3, 2008 at 10:17 pm
I am not sure what you can do in Crystal (unless you have the full blown Crystal+Business Objects suite, in which case you can go with a universe which will...
November 3, 2008 at 8:15 pm
I would usually advise to leave autogrow on. Not leaving auto-grow on means your database runs the risk of running out of space, in which case everything comes to...
November 3, 2008 at 3:04 pm
You may have better luck using a CLR function to assess whether it is a valid fragment or not. This allows you to essentially force the TRY/CATCH one level...
November 3, 2008 at 2:52 pm
You can also skip building the temp table if you use yet another new 2005 feature (a common table expression).
No difference in perf (they actually do the same thing), though...
November 3, 2008 at 2:44 pm
You may find it's not so unaware of the column. If it's trying to passa null value in, it will allow it through.
You could always look at using an...
November 3, 2008 at 12:08 pm
Viewing 15 posts - 2,311 through 2,325 (of 6,486 total)