Search results for query: *

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?

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)

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...

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...

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 :-)

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...

I have a simple Outlook 2002 email form, which has a tiny piece of script that generates a "standard" text type of email and sends it when the user clicks the Send button. However, as well as sending the nice, standard "text" email, it also sends another email which is the...

When running Crystal v7 reports through our integrated product, a particular report that shows text and graphs only shows the text - yet on a machine with Crystal 8.5 Designer it DOES show the graph? Can anyone suggest any checks we can make to establish a possible issue with graphs showing on...

Does anyone know where I can get a crash-course, quick-idea of the security modelling in IIS4 and IIS5, as I've no idea and I'm stuck with issues that are all related to security methinks with no resources to hand?

I'm trying to use a PDA, and installed HotSync on my PC to sync up with the ol' Palm Pilot, but it says COM1 is already in use - by what? How can I find out what is using COM1 at the moment? Any guidance would be very much appreciated.

Is it possible to "control" (somehow) the colours in a pie chart? For example, having the "urgent" issues show a red segment, the "medium" ones an orange one, and so on?

Does anyone know where I can get hold of an evaluation version of release 9 to take a look at?