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

the problem is not about cleaning system views; it's that the old views can now give you inaccurate information; using the newer correct views will solve the issue.

the trouble is...

i thought this was interesting; from what i read on the Wikipedia you have to create a plain text attachment, with specific tags/formats inside that file, and the name of...

it depends on the format of the julian date; here's a couple of examples, but post back how your data is formatted;

DECLARE @sdate int

SET @sdate = 109252

--in AS400/DB2 date is...

can you show us the real trigger instead of pseudocode?

it's running too long because there's an issue, but translating the real trigger to pseudo masks the real problem.

Gianluca Sartori here on SSC posted the code below in another thread, and i really like how well it works. this might help you with what you were after...it...

how would you get the CLR to write the...

maybe he was doing a select * from BillionRowTable so he could see the column names, and the error threw him off.

He may not be familiar with sp_help [TableName] yet.

i would consider leaving the transaction table alone, with one row per transaction, and add a payments table with a FK to the transaction.

that way you can have one to...