Forum Replies Created

Viewing 15 posts - 39,406 through 39,420 (of 39,466 total)

  • RE: sql server6.5 and xml file

    Any chance you could upgrade to 2000?

    If not, you can use ADO to run a query from VB/ASP/VBS and then save the query as an XML file.

    Steve Jones

    steve@dkranch.net

  • RE: Format of Backup file

    You can backup from one server to another. Depends a little on the SQL version.

    For 7/2000, you can use the Enterprise Manager to restore the file, pick device and then...

  • RE: What's a DBA

    Here is my reponse:

    There are lots of different duties for a DBA and there is not good "job description". I actually started an article on this, but it got...

  • RE: Format of Backup file

    No real format. Convention is .bak, but not requird. I have use .dmp before. Just be sure you remember what you use.

    Steve Jones

    steve@dkranch.net

  • RE: alter table and removing IDENTITY property

    Be sure when you do this, you supply a specific identity value.

    Steve Jones

    steve@dkranch.net

  • RE: SQL 2000 Administration Exam

    What do you mean "write the SQL DBA exam?" The exam from MS is already written. You would take the exam I assume.

    There are sample questions in most books and...

  • RE: deny alter table priv - how?

    I agree with Andy. I think the Create Table and Alter Table are pretty tightly linked. I think if you have Create Table, then Alter table is also there.

    I'd go...

  • RE: DSN settings for ODBC connection to SQL 7 Server

    I tend to agree and with Andy and Brian, but I am confused. It's been awhile since I worked with DSNs (too much of a admin pain), but as I...

  • RE: Auto restart SQL Server Agent

    I usually setup MSSQL and SQLAGent to run under a domain account that is a member of some global group so I can assign rights. The account is a local...

  • RE: SQL 2000 Administration Exam

    I used the MeasureUp for the SQL 7 Design exam. It was ok. I've used Transceders for NT 4 exams and they are good, but as a last minute prep...

  • RE: Install Problems

    I fyou change the IIS service to not run the file does it work? I think that you disable te service, start the install and IISReset restarts IIS which can...

  • RE: DSN settings for ODBC connection to SQL 7 Server

    Your post doesn't make much sense.

    Your system DSN specifies the type of authentication (NT Auth or SQL Auth). If you are using NT Auth, then the authentication will actually occur...

  • RE: Install Problems

    I haven't seen this with SQL. I've installed dozens of workstations and servers, all W2K, no issues. This is usually one of the cleanest installs I have seen.

    I would dbl...

  • RE: Auto restart SQL Server Agent

    I assume you have the default W2K settings? Verify this. Be sure no one has changed items on the server.

    Also, is SQL running as a local admin? This might be...

  • RE: Estimating space usage

    You can get the sizes for most datatypes, etc. from BOL or use INSIDE SQL Server by Kalen Delaney. It's a great reference.

    The hardest part will be estimating growth. Get...

Viewing 15 posts - 39,406 through 39,420 (of 39,466 total)