Select * from sys.default_constraints

Here is a cool article about dynamic workflow.

http://www.mssqltips.com/tip.asp?tip=1487

Here is a script that will return all of the information. Do you have to use SMO?

http://www.mssqltips.com/tip.asp?tip=1510

Take a look at this.

http://www.microsoft.com/downloads/details.aspx?familyid=5691ab53-893a-4aaf-b4a6-9a8bb9669a8b&displaylang=en

You can backup your master database just like any other. There is also a rebuildm utility.

http://msdn.microsoft.com/en-us/library/aa214014(SQL.80).aspx

It is MySql. The oj stands for Outer Join.

The { OJ ... LEFT OUTER JOIN ...} syntax shown in the join syntax description exists only for compatibility with ODBC.

The byte array is just a string of compressed data. You should be able to store it in a varchar(max) column.

Try this. You may want to add more conditions like last batch time.

declare @spidstr varchar(8000)

select @spidstr=coalesce(@spidstr,'')+'kill '+convert(varchar, spid)+ '; '

from master..sysprocesses WHERE dbid=db_id('master') and open_tran =...

If you do it in code, you could convert the xml to a dataset and use the following compression functions.

http://www.icsharpcode.net/OpenSource/SharpZipLib/

http://www.icsharpcode.net/OpenSource/SD/forum/forum.asp?FORUM_ID=16

Imports ICSharpCode.SharpZipLib.GZip

Imports System.IO

...

1.Make sure you have enabled Remote Connections in the Surface Area Configurations.

2.Make sure the SQL Server Browser service is started in the Sql Server Configuration Manager.

I think this should do what you want, but I did not test it.

SELECT datename(month,v.SchedBegin) MonthN,

SUM(B.NC) NC,

...

It really depends on the situation, but if you do a left join on the primary table and look for nulls in the secondary table it will return all rows...

select * from sysprocesses where open_tran = 1

Or

Select B.text, A.* from sys.sysprocesses A

cross apply sys.dm_exec_sql_text(sql_handle) as B

where open_tran = 1

See attached...

--Create this function and call it from your query passing it

--dbo.udf_NumXWeekDaysinMonth(CreationDate)

CREATE Function dbo.udf_NumXWeekDaysinMonth(@Date datetime)

RETURNS smallint

AS

BEGIN

Declare @dte varchar(10)

Declare @TestDate varchar(10)

Declare @i smallint

Declare @iNumDays smallint

Set @dte = Convert(varchar(10),@Date,101)

Set @i = 1

Set...