Search results for query: *

Yeah, that is the database name, which is why I don't understand it?

For some reason, the following command generates an error when parsed: BACKUP LOG joebloggs WITH TRUNCATE_ONLY and the error when parsed is: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'joebloggs'. Does anyone know why?

I have a simple problem that is doing my head in because I'm sure I'm missing something really really obvious! Backed up SQL7 d/b to .bak file, then want to restore it to SQL2K server ... and when I try to restore it this happens: Microsoft SQL-DMO(ODBC SQLState 42000) Cannot open backup device...

SQL Server 2000, running fine having just upgraded from 6.5. Trying to apply SP3 and it asks me for sa password, but no matter what I type in (and I'm typing in the valid password) it refuses to accept it? Is there some low-level metabase password that has changed, or something?

Is it possible to hook up SQL Enterprise Manager to manage MSDE server? I'm looking to have a small SQL Server, and MSDE seems to be the answer (cost free, etc.) but I cannot "manage" it (e.g. restore db, create db, etc.) ... if I cannot use Enterprise Manager, then how do I do it?

I understand SQLv7 has server-level sort order, but SQLv2000 has database level sort-order. Does anyone know how you define the database-level sort order on SQLv2000? as I can't find anything on Microsoft website or in SQL Help?

I notice in the PROTOCOLS area, under POP3, that there are various authentication methods available. Firstly, which one is Secure Password Authentication (is that Windows NT challenge/response?) using SSL? and can this be set/unset on an account by account basis?

Can you turn off Secure Password Authentication for a particular account (in other words, at account/login level) on Exchange Server?

Is there a way to list all registered and non-registered files?

Can I delete an .LDF file and then start SQL Server? Will it start okay? (SQL Server 7.0)

... thanks mate, but I've checked that and its not the problem. It tells me that database "Sunrise" has a full logfile and therefore refuses to start SQL Server ... how bizarre!?!

A SQL Server 7.0 won't start, saying that one of the datbases' logfile is full. I'm cool with clearing down full logfiles, but I don't understand how SQL Server won't start due to one being full? Of course, because it won't start, I cannot do anything ... ANY IDEAS ANYONE PLEASE VERY...

You were absolutely right --- brilliant, and thanks for your help. We thought we'd looked everywhere, but obviously we had not !?! Thanks mate.

Every time I send a meeting appointment to a particular colleague, via our internal Exchange 5.5/Outlook 2000 implementation, I get this error: Your message did not reach some or all of the intended recipients. Subject: My New Meeting Sent: 25/02/03 14:10 The following...

Brilliant --- I'll try both ideas right now, thanks ;-)

I want to search a whole database for fields "like" a string, and cannot work out how to do it? I suspect the stored procedures sp_columns and sp_fields could come into play with some flow control, but I simply cannot get my head round it? Does anyone have any ideas?

Someone told me there is a maximum of 255 concurrent users in IIS - is this right? I find it hard to believe, so thought I should consult the experts :-)

Thank you webgs, I will take a look at that authentix software and see what it can offer me. Many thanks for your time and advice. Chris.

Dear all, I am a manager who has recently been "given" the responsibility for an IIS installation/product/etc. and would like to know more about how to control access both internally (intranet) and externally (extranet or internet) from this server. There must be somewhere I can go...

I use the following code: DECLARE curItem CURSOR FOR SELECT MH_Desc FROM Item FOR UPDATE OPEN curItem FETCH NEXT FROM curItem WHILE (@@FETCH_STATUS=0) BEGIN ... etc ... and when I run it, I am told: Server: Msg 16929, Level 16, State 6, Line 7 The cursor is READ ONLY. The error seems to...