I am pretty much in confusion as to which d/b design to choose from I have a Access datafile(.mdb) which is shared across in a LAN. My boss is planning to share it across a WAN.Ours is Head office...there are several branches at some different geographical areas...Hmmm...Is access a good choice in doing so.I mean […]
2002-03-17
6 reads
I have a huge production database over 30GB, the log file looks corrupt (Error: 823, Severity: 24, State: 10)and the db is marked suspect. I tried detaching and just attaching the data portion to a new db but looking at the errorlog it seems to want to open the log as well. Any ideas ?
2002-03-16
1 reads
On a SQL 7 database the following stored procedure was defined. CREATE PROCEDURE LoadPOs @ParentTable nvarchar(30), @ParentID int AS If @ParentID <= 0 Begin SELECT * FROM PO End Else Begin If @ParentTable = 'PO' SELECT * FROM PO WHERE PO = @ParentID If @ParentTable = 'Vender' SELECT * FROM PO WHERE Vender_ID = @ParentID […]
2002-03-14
1 reads
Does installing SQL Server 2000 Standard CLIENT TOOLS only install MDAC 2.6 ? Also, should the SQL Server 2000 Standard SP1 be applied to Client Tools installs ?
2002-03-13
I wrote this procedure with OUTPUT as we still support SQL server7 to return number of business days. I looked at Steve Jones June 2001 function to do this but it seems like if you start on sun and end on sun, it does not calculate number of business days correct. here is an example […]
2002-03-12
2 reads
...in a nutshell? I have been tasked to upgrade our existing SQL 7 servers to 2000. We have purchased the Developer's edition to start testing but I would like to load another copy onto a QA box. Are there any connection (number of) restrictions with this version? When I'm ready to install on our production […]
2002-03-12
Hello, I have a DTS package I can execute using SQL Enterprise Manager 2000. When I make run this DTS as a job, I have the error : "error string : Column name 'Catégo'". I suppose there is a problem with accent letters given to the shell command. I know the best way to get […]
2002-03-12
1 reads
I accidentally delete all the stored procedures in the master database and I were not make any backup and copies of this database. Now it does not allow me to login. How can I do?
2002-03-08
5 reads
Hi, please can anybody help with this... I need to import the content of a mail message into a table. The format of the mail is any number of lines that are all the same number of characters. The way I'm trying to do it at the moment is with an Active X Script Task: […]
2002-03-07
1 reads
Can, should or should not the SQL Server Virtual Server name be the same as the Windows Cluster Virtual Server name? Before installing I assumed that the Windows Cluster Virtual Server name would be used for the SQL Server Virtual Server name. Then the installer wouldn't let me. It said the name was already in […]
2002-03-06
255 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