Logins are OK. I can connect with those logins using any other tool. The connection never reach the server: I ran a Profiler.

No named instances. Good thinking!

Yelena

Noel,

This was a good point. Yes, the database compatibility level is 6.5 on the SQL Server 2000. It can not connect to the server to get a lis of applicable...

You may want to set the appropriate transaction isolation level, see the list in Books Online.

Yelena

Hi,

I don't think that database files could be defragmented while SQL Server is up. They are open files. You may use a maintenence window with SQL Server shut down to...

Hi,

Resore the database on the new server

In Query Analyzer do "Select * from sysusers". This way you will get SID and User Name which is mostly the login name if...

Habib,

Thanks!!!!!! This is EXACTLY that the project manager wanted. She sent me 2 reports that her former consultant used to send to her. They look exactly like the one I...

Thanks for the information too.

Where we can verify the information about the abcense of the agent in MSDE?

Reporting Services: Brian says Reporting Services in Standard are not feature-rich....

Hi,

I just posted  a similar question today about reports output to Excel "Cross-Tab Report Strategies" then I saw this postings. I downloaded examples from the article, got ASP example, modified...

I checked the website

http://www.imceda.com/Backup_Software.htm

The product description did not contain this information and the Support link that includes "Search Knowledge Base" prompted me for the login.

In this particular case I...

You said that the log was full, but the alert was for the DB being full

Yelena

Brian, thanks. Good summary. Still need to know more:

What is BAV saying about Express Edition without Agent? What about the backup job for example? OSQL with Windows Scheduler???

Abour Reports: Developer...

I agree with Francisco. Here is the reference:

http://www.developer.com/net/csharp/article.php/10918_3399881_2

Because an assembly is persisted in the database when the source code for that assembly changes and the assembly is recompiled, you...

Howard,

I had a couple of cases when a service (I think it was SQL Server Agent) was in a strange state: not completely shut down, not completely started. There was...

What do you call "accessing a record?"

When the first user has his application opened? or when the first user is executing a certain front-end transaction? or when the back-end complex...

I would start with checking for any other error / warning messages in all 3 event logs for the exact time you try to start your Agent. Look at the...