How do you know SQL Server was never installed? Could it be that it was MSDE 2000?

Hi,

Do you mean to ask if there is a difference in database design for web and desktop applications talking to SQL Server database?

If this is the question, then I would...

For doing what?

Normally you do have to INSTALL SQL Server, it is much more then the file.

I sort of guessed the "correct" answer.

I have a couple of comments: server does not have a compatibility level. This is a Database property, not a server property.

The default...

Hi,

If you say, this is a simple job to output content of one table to a flat file, just re-create this package in 2005. Right-click on the database, select Tasks...

About the second answer:

FLOOR function according to BOL return a data type of the input expression.

But try this and compare data length of the input and output of the FLOOR...

I tried a few combinations, only the second one returned the correct number in years maybe not as a tiny integer, but correct.

Additionally, everything that requires a variable to be...

I actually was able to follow Asif's article - the link in my post above - and created a Reporting Services simple report on a custom web page.

Hello Asif,

Thank you so much!

I was able to follow your guidelines and it worked with a couple of changes. I used VB on the page and had to translate from...

Thanks, we found them!

I agree. For example we can have a system where Purchase Order will be master data - collections for example.They have static purchase orders and their transactions consist of records...

BOL says in the article "Creating User-defined Functions (Database Engine) ":

"The number of times that a function specified in a query is actually executed can vary between execution plans built...

It really depends.

How big and how often accesses these databases are.

Are they mostly read- or OLTP databases?

Do you have Web or Application server on the same machine?

What are performance requirements...

My RTM BOL says:

The following table contains a list of these statements and expression contexts.

SELECT

INSERT

UPDATE

DELETE

EXECUTE

Sub-selects

DML and DDL statements that appear inside Dynamic SQL.1

1 Synonyms...

I know that it starts sending to the client while the query is still running, for example try to right-click on the big table, click Open and watch as you...