One way to make this process easier is to automate it.

Books online actually list a script that "could" refresh all the dependent views:

SELECT DISTINCT 'EXEC sp_refreshview ''' + name +...

It is actually not such a simple thing. For example the following returns a table with an integer column on Mondays, and a...

In the insert statement you are including in the () 16 column names, but you provide values only of 15 of them, try:

SELECT @sql='INSERT INTO #TAT_Renewal_Results (ProfileID,MembershipStatus,CompanyName,TraderID,CompanyContactFirstName,BillingAddress1,CompanyContactLastName,BillingAddress2,BillingDistrict,BillingCity,BillingCounty,BillingPostcode,BillingEmail,AdvertRenewalPrice,AdvertRenewalDate,LinkedTableName)

'

SELECT @sql = @sql+'...

Are you using dynamic SQL? If not, have you tried adding the parameter/variable to your SQL query whose results you are inserting?

E.g.:

CREATE PROC a ( @param INT )

AS

...

On 2000 there is no varchar(max), but it is common to use ntext or image for xml.

When you say it gets truncated, does it get truncated when you query it...

The restriction for variables is that they start with @. They may contain @ later in their name. The extra @ does not change anything, the author may have used...

Jeff Moden (11/23/2007)

---

DATETIME is really a FLOAT in the background (although it is a "fixed point float", if you can imagine that). DATETIME uses the same BINARY math as...

Have a look at the sys.parameters system view (on 2005, on 2000 look at dbo.syscolumns)

Regards,

Andras

Hi Chris,

honestly I'm not sure if there is a float conversion at...

It is probably worth comparing the query plans. This will give you an idea why the slow one is so slow (it may not use a particular index, ...)

Once you...

Hi Chris,

SQL Server tries to guess the data type of your constants. For 16.0000000385802490 it guesses numeric(18,16), for 16.000000038580249 it guesses numeric(17,15). You could get back the same result if...

Daniela (11/23/2007)

---

Hello

I am using Visual Studio 2005 (C#) with sql server 2005 Express Edition and I want to create a stored procedure that accepts a table as parameter

an parse that...

It is using SQL Server 2005. Steve Davidson, and many other Steves 🙂 could give you more information.

Regards,

Andras

Depends on what problem you are talking about :). They have some nice solutions for scheduling, redundant storage, etc. If you want to read about some of these search on...

You could script your database and keep the script files in source control....