your views and indexes should port right over, but triggers,procedures and functions will need to be hand edited; there just isn't an easy way to move those over, sorry.

Are you...

yes; each service can be uninstalled, or installed after the normal database services install.

Just like any other program, go to add/remove programs in teh control panel, find SQL 2005, adn...

duplicate post...continue to follow the thread here:

http://www.sqlservercentral.com/Forums/Topic653232-149-1.aspx

I'd take a wild guess and say: add up the value of all your machines, servers and printers.

if you assume that a machine should last 5 years before it gets...

[font="Courier New"]

SELECT CONVERT(DATETIME,'20080204') --converts cleanly, and displays as '2008-02-04 00:00:00.000'

SELECT CONVERT(VARCHAR,CONVERT(DATETIME,'20080204'),101) --the desired format '02/04/2008'[/font]

Hi Alex;

Wow if you'd provided that table definition up front, we wouldn't have gone thru two pages of possible solutions and misunderstandings;

Help us help you! when you post in...

I agree with Jeff on the different execution plans...

take this part for example:

CREATE PROC [dbo].[s4sp_IFrames_Search]

@AffiliateId int,

@Zip varchar(12),

@curriculumid int = 0,

@ExcludeClientID int = 0

because you've assigned default values, the execution...

What have you tried so far? what is the real, full CREATE statement for dbo.Alpha? is there a primary key?

how do you know what row either "T" is ? there's...

here is a delete example. hope that helps, without more details it's tough.

SET ROWCOUNT 50000

WHILE 1=1

BEGIN

DELETE FROM dbo.myTable ...

here's a situation where I've expected a trigger to rollback because I raised an error.

http://www.sqlservercentral.com/Forums/Topic622424-338-1.aspx

I've also seen triggers still commit even though a Level 14 error was raised by...

you'll need to explain exactly what you want.

how can you have data BASED on a count if you don't USE a count?

give us the REAL table with sample data, and...

you need to select from the master table, and include the group as a sub select there somewhere, ie

SELECT *

FROM SOMETABLE

INNER...

Here's a detailed explanation i saved from an MS blog a while back:

quote:

--------------------------------------------------------------------------------

The reason for the performance difference stems from a feature called

"parameter sniffing". Consider a stored proc defined...

makjain (2/7/2009)

---

Then too i have 1 question if THEY provide me username and password for sql database then how my web page will work as they have windows authentication.

Will i...

If it's not your own server, for example if it is going to be hosted at GoDaddy or some other host, THEY will give you the user name and password...