cdooley (2/12/2009)

---

I understand the higher numbers are the "next_range", but look at the code below:

if IDENT_CURRENT('[dbo].[ActivityStats]') = @range_end

...

I for one vote FOR the feature. I have lost the count of how many times I have ended using UNION ALL constructs from the stored procedures parameter lists to...

If the IDs are not consecutive the solution is a bit more convoluted:

CREATE TABLE tb (ID INT , Name VARCHAR(20), Title VARCHAR(200) )

INSERT INTO...

Are names unique ?

In all honesty I hope you are not losing data but it is ***VERY*** bad to do that!

First of all you should drop that stat (in case it was "upgraded" from 2000)

Then run an update of the stats with fullscan and also update usage

You are looking for DISTRIBUTED TRANSACTIONS in a way that is not appropriate.

You should re-think your solution.

-Noel

My initial shot in the dark. You have different collations on those servers/databases.

For reasons like this I always use TSQL and specify the path. No UI surprises "ever"!

aldo_marchioni (2/11/2009)

---

There is one more thing to keep in consideration: total cost.

If i can implement Roy's solution, my customer is going to save about 5200 in SQL Server Licensing (that...

Glad you solved.

What I meant is that you needed to somehow (like above using LMHOSTS or SQL Server ALIASES) have direct connectivity.

It is very nice of you to share...

You can use

ALTER SCHEMA Trainning TRANSFER dbo.tablename;

You will lose the permissions though 🙁

The sizes of these files can vary slightly for different editions of SQL Server 2005

Are there any...

kiransuram19 (2/10/2009)

---

we have a partionted view which is created from 16 partionions .

What permissions I have to give to users so that they can execute the view?

I gave db_reader permission...

You can specify the SIZE at creation time.

If you need to get that size automatically every time you create a new DB and your model is 3MB you will have...