Viewing 15 posts - 3,151 through 3,165 (of 6,216 total)
Authenticate within your app, or at the server? Within the app should be doable (not that I know how!), dont know how you'd truly integrate it with SQL, probably best...
September 30, 2002 at 11:43 am
Files are generally set to read only when they get copied off the CD.
Andy
September 30, 2002 at 11:28 am
Try making it a unique index (not pkey) and set the ignore dupes option.
Andy
September 30, 2002 at 9:18 am
Totally agree. I'd be afraid to test for fear it would be faster!
Andy
September 30, 2002 at 9:16 am
Steve,
Not bad code! My only complaint (had to be one, right?) is that I think DTS is overkill. For small amounts of code I'd throw into a job step. Dont...
September 29, 2002 at 8:30 pm
September 29, 2002 at 8:27 pm
Pretty close. Differences could be the # of spindles? Caching is handled by the controller, so it'll either in a util provided by the manuf or in a boot up...
September 29, 2002 at 8:21 pm
The following applies to tempdb only:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q313702
Have you tried dbcc checkdb?
Andy
September 29, 2002 at 4:03 pm
Try set ansi_warnings off. If you dont want to modify your procs, you could just look for the error text of this particular error and strip it out before showing...
September 29, 2002 at 10:45 am
It is pure TSQL or something more complex? Probably a good place to start is to see if you're getting identical query plans. Possibly there is something different between the...
September 29, 2002 at 4:57 am
Agent needs to run under a domain account and will need disk access permissions. Get that working first, then try again.
Andy
September 29, 2002 at 4:53 am
September 29, 2002 at 4:51 am
September 29, 2002 at 4:50 am
At some point trying to send the data via a proc call is a bad idea anyway. For a reasonable sized set (you pick what is reasonable) XML will work....
September 29, 2002 at 4:49 am
Turning off connection pooling seems like a good answer. Or maybe just close your connection as soon as your user is done with db access, increasing the chances that by...
September 29, 2002 at 4:46 am
Viewing 15 posts - 3,151 through 3,165 (of 6,216 total)