Viewing 15 posts - 91 through 105 (of 1,654 total)
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)...
February 28, 2012 at 1:39 am
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...
February 28, 2012 at 1:34 am
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...
February 28, 2012 at 1:26 am
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....
February 28, 2012 at 1:17 am
capn.hector (2/25/2012)
February 27, 2012 at 1:07 am
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...
February 24, 2012 at 1:23 am
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...
February 8, 2012 at 8:45 am
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.
February 8, 2012 at 8:08 am
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 **/
...
February 8, 2012 at 4:23 am
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...
February 8, 2012 at 4:11 am
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.
February 3, 2012 at 12:55 am
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...
February 1, 2012 at 12:40 am
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...
January 31, 2012 at 6:30 am
stephen99999 (1/30/2012)
How can you copy one report, and use that copy to build another report?
In your BIDS project choose a existing report and select the original rdl file. After importing...
January 31, 2012 at 5:47 am
stephen99999 (1/30/2012)
I am using SQL Server 2008 R2 Express and Management Studio Express.
I'm pretty sure that's the reason why you don't see SSRS
January 31, 2012 at 5:34 am
Viewing 15 posts - 91 through 105 (of 1,654 total)