I have configured MS SQL server 7.0 and can connect on that box. When I try to connect through enterprise manager from another box on the network, I get an error message that states, "logon failed for user. Reason: Not associated with a trusted SQL Server Connection. [Driver's SQLSetConnectAttr failed]. The driver doesn't support the […]
2001-11-08
6 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/identityreset.asp
2001-11-02
4 reads
Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!
2005-07-08 (first published: 2001-10-29)
28,883 reads
I am developing a data-warehouse and trying to populate the data staging area from an Informix database using SCO Vision ODBC drivers. I've created the DTS packages (meta data services packages) and set up a job to run them sequentially every night. Most mornings, I come in and the job seems to have got stuck. […]
2001-10-15
Comments posted to this topic are about the content posted at http://www.c-sharpcorner.com/database/dbsqlnet.asp
2001-10-15
2 reads
Has anyone tested multiple instance in Active/Passive i.e having two instances on the same primary node?Due to Licensig requirement we cant go for Active/Active config. If yes do we need to have separate resources like Heartbeat connection etc??
2001-09-14
2 reads
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
2001-09-14
1,145 reads
If I write a select statement against the view using only columns c1 & c2, do the other columns in the view definition, c3, c4 and c5, get read from disk since they are part of the view definition? Thanks in advance for any help. - Brendan
2001-09-13
7 reads
We recently installed a EMC FC4500, and are running SQL2000(ent)on the SAN. We have noticed that the performance on SQL processes is slower (about afactor of6) on the SAN than on the original local RAID. We have noticed that when running the process on the DB that is on the SAN, the number of reads […]
2001-09-07
3 reads
Hello sql server Gurus, I have taken a backup(through maintenance plan) from SQLServer 7.0 server. I wanted to restore that onto SQLServer 2000 database. When ever I try to do that, it gives me the following error message. File you've specified is not a valid SQLServer database file. I am just copying it from the […]
2001-09-07
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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