What error do you get now? Is everyone in that group have the same error/problem when accessing Sql Server?

Have you checked the execution plans each call is using?

If you are getting the "Incorrect Syntax" error, You may want to double check the instance you are running the ALTER LOGIN...

Sorry, I just noted your statement that you are in a group. Your...

paulc.byrum (3/25/2010)

---

The default database is master and it still exists.

I get this when running the commands:

C:\>sqlcmd -E -d master

1> ALTER LOGIN pbtf\bob WITH DEFAULT_DATABASE = master

2> go

Msg 170, Level 15,...

I'm pretty sure some of the Compare Tools have Command Lines utilities to enable automating/scheduling Compares.

I think the error is what is: cannot open your default database.

Does...

Angelindiego (3/25/2010)

---

Hi all. Today's issue is that I need to come up with a script that will loop thru the databases on a server and compare each database for...

SQL_Easy_btn? (3/24/2010)

---

I have been messing around with a solution for a customer and need to do a BULK INSERT from a Tab delimited file.

I have no control of the data...

You are welcome.

This are the steps in SSMS for Sql 2008 but I think it should work for 2005:

Click on the Tools menu option in SSMS.

Click on Options->Query Results->Sql Server->Results to Grid

Tick...

I'm not quite sure what you mean.

Commercial applications for database administration, maybe?

Cool link. I like it 😛

It would appear that the clause:

inner join WhitePage w on w.displayname = a.displayname or w.eid = a.eid

is forcing a Clustered Index Scan on the Whitepage table. Thats where the time...

I'm not sure posting your query multiple times would help get your question answered any quicker:-D