SELECT OBJECT_NAME(OBJECT_ID),*...

Bhuvnesh (6/30/2010)

---

ALZDBA (6/30/2010)

---

Select @@version[/code]

Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT...

ALZDBA (6/30/2010)

---

Select @@version[/code]

Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2...

i am sql administrator, is that enough for it ?

Google Sp_send_dbmail

why ? what issue you got ?

i dont know your exact requirement but you can give them conditional flow of businees flow, if you know that . i guess high level view will work for them.

you mean to say execution plan .. i dont think there is any word like "flow chart " for queries

you can use "include actual exec plan" available in...

USe sp_send_dbmail including Query parameter.

Try this

IF EXISTS (SELECT name

FROM sysobjects

WHERE name = N'up_AllProcPermissionsForDB'

AND type = 'P')

...

try this ...some what like your requirement

SELECT '''' + cast(value as varchar(2000)) + '''' FROM ::fn_trace_getinfo(0) where property = 2

SELECT ...

Eric.Johns (6/24/2010)

---

What would be the best thing to do, query performance wise, as far as a FK in my new table, using the 4 int columns or the nvarchar(30)...

i have some confusion here , if the column is identity--auto incremented then how duplicates records generated ?

Have you tried through scripting ? addtionally is there any mgmt window opened ( using...

Tara-1044200 (6/22/2010)

---

i did rebuild indexes month ago which is done from an automated jobs (rebuilds/re organize as per gragmentation level ), do you think that might caused to drop...