Raj,

I don't think you will get any general useful answers to your question. Performance is depending on so many things besides RAM. What about CPU's (how many and how fast)...

Haven't done it for a while, so I'm not sure if you can choose it using the setup wizard, but the mergeagent has a property called exchangetype, which basically defines...

Basically I think you have two options.

One way would be starting your SSIS packages using the dtexec command line utility and use Windows Task scheduler to schedule them. That's...

First of all the public role shouldn't have any permissions assigned to it unless someone granted them explicitly. By default the public serverole only has connect permission to the server....

capn.hector (2/25/2012)

---

I have a job on server 1 to backup, zip and copy database a to server 2. a job is then scheduled on server 2 to unzip and...

sqlwb32 is actually Management Studio, not the server itself. @@Version will give you the version of the server you're connected to.

So in your case you are using a 32-bit client...

I never really worked with dbo.RunningJobs and since it's not documented you have to be careful, when making such assumptions.

When I just tried to catch a report in dbo.RunningJobs it...

In the table "ExecutionLog" you'll find a column called "RequestType".

If the value for this column is 0 that means it was run interactive, 1 means run buy a subscription.

You have to use dynamic sql. This should work:

DECLARE @counter INT

DECLARE @count1 INT

DECLARE @cmd NVARCHAR(4000), @quarter VARCHAR(10)

SET @counter = 1964

SET @count1 = 1

/** Insert data from moodys extract **/

...

It seems like you tried to remove the distribution database on a server which has no such database. This doesn't have to be an issue because in a typical replication...

Varchar(max) was introduced in SQL2005.

In SQL 2000 you had to use the text datatype if you want to store more than 8000 characters.

To find jobs which have a different owner than sa use this:

select * from msdb..sysjobs

where owner_sid <> 0x01

The reason you don't get any results from my first script is probably...

It's not exactly T-SQL, but can't you just put your query window in sqlcmd mode and use the :CONNECT command?

See here for examples: http://www.mssqltips.com/sqlservertip/2311/using-the-ssms-query-editor-in-sqlcmd-mode/

The query get executed on the server...

In your BIDS project choose a existing report and select the original rdl file. After importing...

I'm pretty sure that's the reason why you don't see SSRS