In SSMS, right-click on the database, goto Tasks, then Generate Scripts 🙂

Thanks,

Jared

When you set up a maintenance plan, it creates an ssis package and then schedules a job. You must check the credentials on the maintenance plan itself, and then...

You could still modify what I gave you by inserting the queries used for the temp tables into the from of the final query as subqueries. Union the first...

Try this:

CREATE TABLE #TEMP (branch_plant int, item_number int, qty int)

CREATE TABLE #TEMP2 (supplier int, branch_plant int, item_number int, long_item_number bigint, item_description varchar(255), consign_on_hand int, warn_on_hand int)

--Insert data into first temporary...

This is really an over excessive use of sub-queries. There should be no reason for this. Let me "detangle" this and make some sense of it and I will...

A subquery does not know what is outside of it. It only knows what is in itself. Only the larger query can read into a subquery, not the...

I think that with the information given, that this is the best approach. Although changing the database and table design may be more beneficial, I am not suggesting anything...

Ok, this will not work:

USE MASTER

GO

create database distribution on

(filename=''),

(filename='')

FOR Attach

go

This creates a user database named [distribution].

I don't understand what the current issue is... You want to remove distribution in...

I would do this if it is feasible:

SELECT p.PartNum, a.Data, b.1Data, b2.Data, ... , n.Data

FROM PARTS p

LEFT JOIN DataTableA a

ON p.PartNum = a.PartNum,

LEFT JOIN DataTableB b1

ON p.PartNum = b1.PartNum

AND b1.Data...

Also, for what reasons are you using a second server as the distributor? There are reasons for this, but there may be better reasons to keep the publisher the...

Try this: http://msdn.microsoft.com/en-us/library/ms151192.aspx The idea here is that you cannot just create a distribution database the way that you did. This page will show you how to do it...

One more link pon using server side trace, but not scripting it.

http://sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/%5B/url%5D

Thanks,

Jared

Grant Fritchey (8/31/2011)

But, running the Profiler GUI against a production server is somewhat risky. The GUI works differently with event queues in the server and can negatively impact the server....

Run SQL Server Profiler and filter the database name to the one you are interested in. Monitor it for as long as you see fit to determine usage. When...

You will have to call Microsoft to double check, but I believe that the only difference between Enterprise and Dev edition is the license. You should be able to...