hi once again, i am working on MS-SQL 7.0. Just Recently we have shifted our database from Access to SQL 7.0. I had normalised the database till 3 NF. Now I am having a field that takes up the office address. The value of the city, state and country comes from 3 different tables. We […]
2001-08-22
2 reads
Hi all, Does any one know what hapend whith one trigger, when I execute one "BULK INSERT" statement in one triggered table ?! Why trigger are not fired ?! Thanks WolfJr
2001-08-21
2 reads
Last Friday clients started receiving the intermittent error "A database error has occurred: Database error code: 10008. Select error: Possible network error. Bad token from SQL Server: Datastream processing out of sync". The server (NT 4, SP 5, SQL 6.5.416) event log shows Error 17824:Unable to write to ListenOn connection '<server name", loginname 'xxx', hostname […]
2001-08-21
4 reads
Hi all At present I have both read ahd write cache enabled on my RAID-5 array (4x15k 18gig drives). From what I understand, the write-caching at the hardware level is basically hidden from SQLServer, therefore, sql*server will assume that the write was successful. This of course means without a good battery backup scheme and possibly […]
2001-08-21
41 reads
Hello, I am trying to write the output of a stored procedure to a txt file. I am unable to find any technical matter on the same. can anyone help me in this regard. I want to call that output txt file from a ASP page later. Thanks
2001-08-21
310 reads
I have inherited the SQL server. The password for many logins are not passed on to me. Is there a way I could look into the system table to retrieve the passwords? Some of the client-server based applications could have hardcoded the password and if I change it on the SQL server end, it will […]
2001-08-20
2 reads
I'm trying to use SQL-DMO to determine the size of the "northwind" database: Dim oSQLServer Dim oDatabase Set oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.Connect "tower2", "sa" Set oDatabase = oSQLServer.Databases("northwind") Msgbox oDatabase.Size but .Size always returns the results in MB (not fine enough for me). For example, on my computer it returns 5 (MB) while EM show […]
2001-08-20
3 reads
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
2001-08-20
8,199 reads
hello once again, this time i have encrypted a view and when i open its design view the error comes as : "query designer encountered an unexpected error cant open encrypted view " but the data in the view is seen, now i want to modify the design view but its not working any ideas […]
2001-08-18
3 reads
hello andy, what i mean by not displayed is that the value for that particular field is being shown as <"Long Text"> and nothing else will try convert ok will let u know if something clicks by using convert thanks keyur
2001-08-17
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