Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 1,523 total)

  • RE: install of sql srv 2005

    Hum... I guess I have never had a null password.

  • RE: install of sql srv 2005

    This is the script I use to script out SQL Server id/passwords. I save this off for disaster recovery purposes AND to move logins between SQL Servers. The only requirment...

  • RE: Clustering.

    Setting up clustering is not for the novice. You have to have MSFT approved servers (we found this out the hard way... our first ones were not and we had...

  • RE: disaster recovery

    One other thing. Once a month the master list of 'sa' and other login/passwords is burned to CD once a month and taken offsite as well.

  • RE: disaster recovery

    I have a document showing what servers we have running SQL Server, what version of SQL Server/ Service pack, what version and service pack of operating system and what databases...

  • RE: dbreindex - how does it work

    Someone correct me if I am wrong. If the table(s) in question do not have a clustered index then rebuilding the indexes on that table will not defrag the index....

  • RE: Failover Clustering Qs....

    I cannot answer Active/Active questions since I have no experience with them but I don't think you can mix active/active with active/passive. There would be an IP conflict and a...

  • RE: Restore .dat in SQL Server 2000

    Try backing up the db again to a new file and then try the restore. i think the file is somehow corrupt.

  • RE: Restore .dat in SQL Server 2000

    You need to give us more information on what you are attempting to do and what type of file you have. I once got a db backup from a company...

  • RE: Time Off

    Last year I found I had very high cholestrol. I decided, among other things, to start walking more. So, after lunch I walk two laps around the back of our...

  • RE: Profiler capturing info for a specific db does not work.

    Awesome ! Thanks, don't know why I did not think to try that... That is what these forums are good for !

  • RE: ERROR :3242

     I have gotten this error before in SQL 2000 as well. The file is either corrupt or was transferred in an incorrect format that is no longer readable via SQL...

  • RE: Installing Management Studio on my PC.

    On the install DVD. It first wanted the 2.0 .net installed, that is fine then it said I needed Visual Studio installed and gave me options of full install or...

  • RE: Opening up Management Studio taking several minutes

    Thanks for your assistance. I just found a KB article that states on the 64 bit platform that Mgt Studio will take quite a long time for certain operations. This...

  • RE: where does my sqlServer2005 insallation store its bak files?

    Program Files Microsoft SQL Server MSSQL data backup.

Viewing 15 posts - 1,351 through 1,365 (of 1,523 total)