Viewing 15 posts - 2,041 through 2,055 (of 6,216 total)
I've found that a locked bit isnt enough, I want to know who locked. Lots of times an app/connection will drop, leaving the lock bit set. We go with the...
June 12, 2003 at 11:44 am
They surrender some privacy when they connect to the db. Think of banking - would you want a banking system that didn't trace every access/change? Or healthcare? Profiling is just...
June 12, 2003 at 9:25 am
Guess Im with the crowd - we reboot when we need to, which is usually service pack application. I ALWAYS reboot after a service pack, whether it says to or...
June 12, 2003 at 9:21 am
Not built in. You'd have to track who was connected, then either queue the requests (if dynamic sql) with a configurable priority, or a more brute force way would be...
June 12, 2003 at 9:11 am
June 12, 2003 at 9:11 am
Nice part is the licensing is the big part, doing the upgrade is very smooth.
Andy
June 11, 2003 at 4:42 am
The next version of SQL - "Yukon" - will .Net integration, allowing server side code to be written in a .Net language, should offer similar capabilities. For now the best...
June 10, 2003 at 5:24 am
Could use DMO to do it, something like this:
Dim oServer As SQLDMO.SQLServer
Dim oproc As SQLDMO.StoredProcedure
'connect
Set oServer = New SQLDMO.SQLServer
oServer.LoginSecure = True
oServer.Connect "Roosevelt"
'get the proc we want to copy
Set oproc =...
June 10, 2003 at 5:22 am
Are you referencing a linked server? It has a property you have to enable to allow data access.
Andy
June 10, 2003 at 5:15 am
Not bad. You could also write something to pull scripts from a folder and execute. In either case you have to have a way to establish the order to process...
June 10, 2003 at 5:14 am
Not really. Set based triggers are nice for performance, until you need to do something like you have here.
Andy
June 10, 2003 at 5:12 am
June 10, 2003 at 5:09 am
SP_oa~ series procs let you interact with COM objects, so you could compile it with the COM interop setting, access it that way. A different way would be to shell...
June 9, 2003 at 1:36 pm
June 9, 2003 at 1:34 pm
SQL is just the data layer, as long as you have an OLEDB or ODBC drive you can access it. ASP, JSP, whatever, all are different ways of presenting data.
Andy
June 9, 2003 at 1:33 pm
Viewing 15 posts - 2,041 through 2,055 (of 6,216 total)