What is the procedure for starting MSSQL Server in Single User Mode. When I give the command \mssql7\binn\sqlservr.exe -c -m from the Command prompt the server starts coming up but after a few mins it halts. In short the sql server does not start in single user mode on my PC.
2004-02-23
hi Phill your reply was very helpful, thank you. we don't the process at the moment. what we are trying is: VB 6 front end and SQL 2K back database. then we need to send this data to other department. In other department they use Progress front end and Progress database as back end. Once […]
2003-09-03
2 reads
2003-08-25
I work for a small company and I'm the only computer geek in the office. Basically, I'm what they call a System Builder. It's really hard trying to explain Quality Assurance to two people who have never worked in a large company. Thanks for the help, Frank. I would love to find some formal documentation […]
2003-08-08
1 reads
For example, let's say for a simple SELECT query, I can whip out a query with 20 columns in 20 clicks (20 seconds) without keying in a single word in EM. However, to produce that same query in QA (even with dragging the column names from the Object Browser), it takes me one to five […]
2003-07-25
quote: I don't put a lot of trust in getting everything sent from any one source. So I sign up for multiple ones. that's a kind of paranoid thinking I like! Cheers, Frank
2003-07-11
If your in coming data is sorted according to the index specified in the destination table you get will sorted data. If, however, the data file is sorted in different order or no order is specified records will inserted randomly.
2003-07-01
1 reads
Short of changing the table definition through EM, there is no scriptive way of doing what you are trying. You cannot ALTER TABLE to make a column an IDENTITY, but you can change the table design via EM - and you will lose all data that exists in that column. You can though ADD a […]
2003-06-27
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