Scott Coleman (10/1/2013)

---

Here are two versions, column lists removed for clarity. Don't rely on "SELECT *" to work across servers.

-- V1: Copy the entire remote table, keep only what...

Jeff Moden (10/1/2013)

---

halifaxdal (10/1/2013)

---

I did the following to empty ldf: 1. Put the recovery mode to simple; 2. dbcc shrinkdatabase('database_name')

This made the ldf to minimum from 99GB down to 1M

I...

Thanks For Replies Above.

I have been able to resolve this issue:

1. Select enough amount of records into a new table

2. Truncate the original table as most of the records are redundant

3. Delete the...

I did the following to empty ldf: 1. Put the recovery mode to simple; 2. dbcc shrinkdatabase('database_name')

This made the ldf to minimum from 99GB down to 1M

I then tried to...

That was simpler, isn't it? Thank you very much, I was thinking in...

Thank you, that's what I want

Look good but the code

ALTER TABLE SalesDates DROP CONSTRAINT DF__SalesDate__saled__4ED6BD4A

indicates the script knows the constraint's name in advance.

Since there are lots of fields for each table, I can't manually...

Thanks.

Then how do I loop each field and find if there is a constraint on it? and get the constraint's name if I have to put the name there when...

You are right, it's not sp, it's a view, my mistake.

select definition from sys.sql_modules where object_id = object_id('sp_procname')

is better than mine.

Thank you

I end up using this:

declare @result nvarchar(max)

set @result = ''

select @result = @result + text from syscomments

WHERE id = (SELECT id FROM sysobjects WHERE name = 'spname')

ORDER BY colid desc

select...

Thanks. EXEC sp_helptext returns row by row while I want only one row

That's easy, isn't it? Thank you.

Thank you for the quick...