I agree I have not really understood why the schema concept is there. It has caused more problems for me that it has been useful. We have a research dept that I got tired of creating hundreds of views for so I finally gave them Enterprise Manager and only gave the rights to create views. […]
2003-05-21
1 reads
First make sure you are closing your connections immediately when processing is done (do not set connect = nothing as this is what keeps ppoling alive). Also, my understanding is the Pool SIze is dynamic and relates to the avaialble memory. I would open Profiler and check the number of Open Connections and the amount […]
2003-05-21
1 reads
Hi, here is a snippet of a jsp page I built just for fun to test java?!? and SQL Server. www_assetlist is a view on the SQL Server. <% String lpszSQL; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch (ClassNotFoundException e) { out.println("<h1>Driver not found:" + e + e.getMessage() + "</h1>" ); } try { Connection conn = […]
2003-05-21
Sorry for your head 😉 Yes I’m able to connect to the server by “BUILTIN\Administrators” but I remove it for security reason. I can also connect to a DB of the SQL Server if I set some right to a Domain User like “Domain\Richard”. All the permission is set in the sysmembers table. But It […]
2003-05-20
quote: From tools --> Add-Ins --> Linked Table Manager --> select tables you want to refresh. Now I know what you mean. Sure that works, but I prefer to quickly drop the link and relink again. I feel more confident with this Cheers, Frank
2003-05-20
When I make the query fail by using a bad field name the debug data shows that the data source is indeed Exec_exec_test -- the same one that the query analizer is using.
2003-05-20
Ack! Posted before I was finished. The SQL Server Agent account should be a member of the local Administrators group for the autorestart function. I've run into to too many situations where the agent service dies for one reason or another and without the autorestart it can become serious very quick if you rely on […]
2003-05-19
I'd also check the memory usage for the SQL instance. Compare it to what was being used before SP3 was applied. I have seen SQL Server start escalating to table locks when the amount of available memory is insufficient for the current activity. In particular, this occurred to us one time when someone fired up […]
2003-05-19
Thanks Brian, The article answered some of my questions. Thought: Could you not delve into SQL and add a trigger to sysObjects, SysColumns(?) so that when a table was created it re-ran the script? A problem I face with your solution (Mine included) is some of the DB's get restored often. This erases the permissions […]
2003-05-19
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-19
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers