ryan.mcatee (3/12/2013)

---

To clarify, say we have three tables:

schemaA.MyTable

schemaB.MyTable

dbo.MyTable

If my current-logged in user's default schema is schemaA and the default schema for the database is schemaB. And we create a...

the default DelimitedSplit8K is...

i would think it depends on the query; if the query is returning a million rows with text data, there's not a lot to do;

but depending on the query,...

ok dumb question time guys:

i also have 4 instances on my developer machine, for versions 2005 thru 2012.

when selecting the memory counters in Perfmon, i see instances for 2008, 2008R2...

actual foreign key constraints cannot expand to objects outside of the existing database.

you could potentially create a user defined function that is used as a CHECK CONSTRAINT, which checks if...

if i read youre request wrong, and you wanted to review the results of your trace, i use this:

--SELECT * from sys.traces

declare @TraceIDToReview int

declare @path varchar(255)

SET @TraceIDToReview = 3 --this...

Tripped over this same issue myself, even wrote an article about it long ago;

this is a much-improved-since-that-article version of a proc I've created this procedure named "sp_ScriptAnyTrace"

which scripts out...

Jim i am thinking something more like this, i think; i'd need the DDL and sample data to really make a solid mockup

CREATE VIEW VW_TimeSheetStatus

AS

SELECT

CASE

...

JimS-Indy (3/8/2013)

---

I have a TimesheetMaster table which requires 1 or more "approvals". I've created an eventlog table to keep track of approval events. Now, if any approver rejects a timesheet,...

from my snippets on finding dependencies for a specific column name;

SELECT

depz.referenced_schema_name,

depz.referenced_entity_name,

objz.type_desc,

colz.name AS ColumnName

FROM sys.sql_expression_dependencies depz

INNER JOIN sys.objects objz ON depz.referenced_id=objz.object_id

LEFT OUTER JOIN sys.columns colz ON objz.object_id =...

doing the alter database [dbname] set single_user with rollback immediate is great, but only if your connection is using the database.

if you are looping thru them all, i can...

Yes print messages are available as part of the. Net connection object but you have to add a event to it i believe in order to extract them. I have...

i believe he's not talking about the registry for installed machines, but rather the saved connections that SSMS might have connected with in the past.

those connections are stored in a...

maybe i'm reading the requirement differently;

it sounds like the Developer has db_ddladmin.

if the developer creates a new object, he of course has access to it, because he was the creator,...

interesting that it's different for the 4k sectors;

in your code, i guess you'll check the size,and if it is zero, try the 4k sector size method instead?

that'd work i...