Are the apps all accessed via a browser? Could you put a block on all access attempts that don't originate from the web server or IT computers?If the apps connect via ODBC and use standard SQL authentication, do the users know the password to get them through the ODBC connection?I would also take the political route […]
2005-02-02
I didn't write the question, but I was under the impression that the website might use it's login, which would be a single login. I think it also depends upon the architecture of the system. If it's multiple users, then the comments above are very valid.
2005-01-18
Hi,I want to import a simple XML file into a database table. the problem is thant in DTS, there are no connection to an XML file. Can you help me to do so from a DTS.thanks.example: xml file is <root><person><name>person</name><age>25</age></person></root>
2005-01-09
213 reads
This is a common misunderstanding of the Table valued Functions.Supose your function returns Different result sets for different arguments HOW is the JOIN you are trying to accomplish going to be resolved?Join to the first, second, third .... resulset or it would be any combination of those? ... Of Course SQL has to complain about that. […]
2004-12-23
I'm going to loading a new server with SQL Server 2000. What do I need to do to have the System databases (master, model,msdb.etc) load into a specific location. Do I have to move them after the fact? I want them to reside on a different drive from the SQL Server files. Any articles that speak […]
2004-12-23
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
Both SQL Agent and MSSQLSERVER services start with the same account ..that account has local admin rights. Job is being run right at the server (remoting in using same account as the one the services start with). It wasn't whether it was being started using format or not ..what the problem ended up being was […]
2004-11-22
Thanks Peter, but it only has the .mdf and .ldf files not the location of the .BAK. Still looking, Steve
2004-10-07
SELECT TOP 1000 WITH TIES DT.telephoneid , DT.RequestsFROM (SELECT telephoneid,count(*) AS RequestsFROM tblGROUP BY telephoneid) AS DT.ORDER BY DT.Requests DESC This will return the TOP 1000 but also take into account situations where record 1000 and record 1001 have the same number of requests.
2004-10-01
I am converting a report from Crystal to Reporting Services and I need the ability to look ahead by one row (the Next command in Crystal) and use this data from the result set to perform certain calculation.If there is not a similar comman is there a way to do this short of creating a […]
2004-09-22
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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