How to add processor in SQL Server

Hi,
I am having 4 processors in NT
But SQL Server is showing only 2 processors
(checked in processor tab in server properties window)
I want to use 3 processors for sql server, Could you
please me how to configure the third processor.
Regards,
Sateesh.Unless your using the Desktop or Personal editions of sql server it should
see and utilize all 4 processors. What edition are you running?
--
Andrew J. Kelly
SQL Server MVP
"Sateesh" <tummaganti@.yahoo.com> wrote in message
news:093201c38927$aabe1660$a401280a@.phx.gbl...
> Hi,
> I am having 4 processors in NT
> But SQL Server is showing only 2 processors
> (checked in processor tab in server properties window)
> I want to use 3 processors for sql server, Could you
> please me how to configure the third processor.
> Regards,
> Sateesh.|||What does XP_MSVER report?
"Sateesh" <tummaganti@.yahoo.com> wrote in message
news:093201c38927$aabe1660$a401280a@.phx.gbl...
> Hi,
> I am having 4 processors in NT
> But SQL Server is showing only 2 processors
> (checked in processor tab in server properties window)
> I want to use 3 processors for sql server, Could you
> please me how to configure the third processor.
> Regards,
> Sateesh.

How to add link in a report as a button?

Hi,

I want to add a link in a report, possibly a url link or a link to other report. One way of doing this is to go to properties of textbox and then update the jump to option.

But how to do this through a click of a button, inside the report?

I am having Microsoft Visual Studio 2005, designer's version.

thanks

You can use the Action property of a textbox and format that as a standard link (underlined).

For a 'button', I believe you'd have to make an image per button and then use an image control, and again leveraging the action property.

There may be custom controls out there that will make the button for you and you'd just set the caption.. but I don't know for sure.

How to add date and time to Flat File Connection Manager

I have specified a name for my output file in the properties of my Flat File Connection but how can I add the date and time to that filename? If it is using expressions, what would be the expression and where exactly do I paste that expression?

Nice one:

Expression:

"FileNameBase_" + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()

Looks like this:

FileNameBase_2006-01-03_08:55:28

Place is on the Connection String property of the Flat File Connection Manager.

HTH,

K

|||

I have the following expression attached to the ConnectionString property of a File Connection Manager:

@.[System::PackageName] + (DT_STR, 4, 1252) DATEPART( "yyyy", @.[System::StartTime] ) + RIGHT("0" + (DT_STR, 2, 1252) DATEPART( "mm", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "dd", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "hh", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "mi", @.[System::StartTime] ), 2) + RIGHT("0" + (DT_STR, 4, 1252) DATEPART( "ss", @.[System::StartTime] ), 2) + ".log"

Which looks horrible, I know, but evaluates to something alot more user-friendly:

PackageName20060103084130.log

You can choose to make this as difficult or simple as you like. For example

@.[System::PackageName] + (DT_STR, 30, 1252) @.[System::StartTime]

evaluates to:

PackageName03/01/2006 08:41:30

Hope that helps!!

-Jamie

|||Thanks a lot! this gives me a real good start to working more with expressions in SSIS|||

one more question. I tried putting it at the end of my string but it doesn't like it because it is malformed:

C:\Documents and Settings\sss\Desktop\output.txt + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()

|||

Gotta escape the '\' character and gotta be in quotes... :)

"C:\\Documents and Settings\\sss\\Desktop\\output.txt" + (DT_WSTR,15)(DT_DBDATE)GETDATE() + "_" + (DT_WSTR, 15)(DT_DBTIME)GETDATE()