Forum Replies Created

Viewing 15 posts - 31 through 45 (of 100 total)

  • RE: login failed

    Spectra,

    Are you attempting to connect to the database via an application?  If so then connecting using the sa password is very bad practice due to the sa account having full...

  • RE: Restoring Database--Missing Proc,Tables& columns

    Rama,

    Exactly which tables appear to be missing in the restored databases do they all start with the letters sys?  Are the Linux applications working as expected? 

    To get a really good...

  • RE: BCP? Is there a better way?

    Andrew,

    I think you're after the BULK INSERT T-SQL command, checkout BOL 'bulk insert' under 'Transact-SQL Reference.  You can then use the ROWS_PER_BATCH or BATCHSIZE arguments.

    NOTE: Be sure to size your...

  • RE: Database create policy

    Michael,

    Size and sizing databases can be confusing for some people (it's also a bit of a black art in DBA'ing), it may be worth changing this to 'Approx number of...

  • RE: Database Design Query

    M,

    Carolyns right, you really need to employ some decent database design to this, i.e. Nomalizing the design, i.e. splitting the data up into manageable tables and reducing duplication.

    A good start...

  • RE: REplication from SQL to Oracle

    SQLRep,

    It should be possible for you to create a push subscription from your SQL Server 2000 server to an Oracle (ODBC) subscriber, this is referred to as Publishing to heterogeneous...

  • RE: what to do if moving SQL servers and specs are not same?

    TK,

    I'm assuming you are building the new server on new separate hardware? 

    Below is the approach I would take (given the information you have provided and lack of knowledge of and SLA's etc.).

    1) Upgrade the...

  • RE: Linked Server - Windows Server 2003 and MSDTC Issue

    Dave,

    What is your (target) linked server, is that a Windows 2003 server as well?  I had this problem some time back and then made the following changes within the 'Security...

  • RE: Migration of Databases to New SQL Server - HELP

    Mark,

    This MS article explains a lot of what you are asking, in particular your security questions are discussed in Step #2.

    ll

    oh yes, sorry about that, got distracted adding it to...

  • RE: Excel Linked server

    Stephen,

    Have you checked the SQL Errorlog to see if you're getting anything reported in there?  May also be worth changing the audit level so that you capture failed logins (if...

  • RE: corrupt mdf and ldf file

    terry,

    there is no way to do a restore from the original MDF files.

    i assumed you had already tried the standard attach in your first post 'Exec sp_attach_db 'SUSDB', 'e:\wsus\susdb.mdf', 'e:\wsus\susdb_log.ldf''

    it...

  • RE: Why are SysAltFiles and sp_help_DB returning different files for TEMPDB?

    glad you got it figured out.

    may i ask why you are simply removing the SQL service account from local admins?  also are you using a local or domain windows account? ...

  • RE: corrupt mdf and ldf file

    right terry,

    first of all, did this database originally have multiple log files?  see here: http://support.microsoft.com/kb/q271223/ if it did, there's not a lot we can do.

    what process did you originally use...

  • RE: corrupt mdf and ldf file

    terry,

    have you changed the physical filenename of the data or log files?  can you post the query you are running to try and attach the single file.

    thanks,

    ll

  • RE: corrupt mdf and ldf file

    lowell has a very good point, move/archive (on another physcial drive or folder) any other log or data files you have related to the original database (including the corrupt log file...

Viewing 15 posts - 31 through 45 (of 100 total)