Rodney

That's right.  If you don't want that, then the only thing I can think of is to create a job that checks for objects not owned by dbo and changes...

Biju

It looks as if the data impiort process uses temp tables.  You need to expand your tempdb so that it can accommodate all the necessary objects.  Right-click on tempdb in...

Have you looked at creating a DTS package?  You can copy tables, users and other objects from one database to another.

John

Rodney

I take it you have added him the the db_ddladmin database role?  All you need to do is have him create tables as follows:

create table dbo.NewTable (<column spec&gt

Something like this?  You'd have to test it for performance if you have thousands or millions of programs. I haven't done the concatenation to show 1/4, 2/4 and so on...

Murtaza

I would imagine that joining on such a wide column would cause performance problems, especially as your table gets to millions of rows instead of thousands.  Assuming you have a...

Prakash

As long as you're not replacing the C drive, and as long as the D drive only holds database files, I can't see any reason to reinstall the operating system.

The...

Try running the following query:

sp_MSenum_replication_agents @type = 3

This is what Enterprise Manager runs when you click on the Distribution Agents folder.  Does it return what you would expect?

John

MK

Which computer are you looking on - the Publisher, the Distributor or the Subscriber?

John

No need to cross-post.  Although this is the (more) appropriate forum, I've answered in the first place I found it, here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=284840

You need to reboot the server if you are modifying boot.ini.  Don't forget to change boot.ini on all cluster nodes.  I assume you are increasing memory on all cluster nodes?

Also,...

You can specify which tables go on which filegroup, so if your data files are in different filegroups from each other then you will be able to do what you're...

"JM - I think the params to the function would be customer and item, not Sold_Qty"

Tim

I haven't got a great deal of experience with functions, but if we make an...

Can you not use a GROUP BY to list all the customer/item combinations and a user-defined function to get the average of the latest five?  Something like this:

SELECT Customer, Item,...

Stewart

Yes, the folder needs to exist, and the account you use to start SQL Server needs read and write permissions on it.

I do not recommend backing up to a network...