dates have to be encased is single quotes, as they are not a number.

instead of this:

<= 01/31/2011

--change to this for example

<= '01/31/2011'

change it everywhere you had date strings.

this command seems to be working for me to return results on a per-db basis...is that what you wanted?

sp_msforeachdb

'select ''?'' as dbname,*

from sys.dm_db_index_usage_stats

where database_id = db_id(''?'')'

help us help you...when i read your question, i think the question is "when i profile my procedure, it never finishes. when i just run it, it is fast"

is that...

in 2005 and above, there is a DMV that has the IP address, but note it's possible the value ls '<localhost>' or null if they connected via shared pipes.

...

wow, so even if you were to drop the table itself in the original database, the space will not be recovered? is that right?

no, removing ad hoc will not affect your replication.

in 2008, it's a right click with the SSMS object explorer on the server and go to "facets": disable these two items...

could you be trying to connect with a lower version of SSMS, for example the Express Version that comes with Advanced Services?

That limited, express version does not let you connect...

not without something keeping track of those references;

object dependancies are limited to exist inside a database...that way if you backup and restore, everything your object referenced are together.

because multiple databases...

SQL server is already like that...once the sysadmin restores or creates a database, NOONE has access to it, except the sysadmins.

as long as no one except the dba has sysadmin...

Rajendra.soni (11/15/2010)

in SSMS, Tools --> Options --> Query Results --> Results to Grid --> Max characters Retrieved --> Non XML Data ,

it...

there is a view you can select from, and a function that you can use as well:

select * FROM fn_listextendedproperty (NULL, NULL, NULL, NULL, NULL, NULL, NULL);

select *...

like i mentioned before, the only solution is to take away the sa login from everyone, and make them login with something else.

in a place where everyone has been using...

it sounds like the password that is stored for running the full text service is out of date/changed;

Control Panel>>Administrative Tools>>Services>> find the full text service (my 2008 was named "SQL...

you'll want to revamp how you are currently doing access;

first, to be clear, a login has one password only. you...

what you'll need to do is make sure any paths for file names exist in double quotes...that is what the OS requires for file names with spaces; my dbl quotes...