Take a look at the SSIS packages to see what are they doing. To do that, create a new BI...

This is true, but we're talking of the express edition, which have some limitations that you don't want...

Hi there,

Based on my experience, having local admin rights to the server is really important, but that does not mean that you should connect anytime you want to perform things...

Hi,

First of all, why are you trying to create a database with the datafile located at C:\Documents and Settings\morase\Desktop\Copy of BPO Portal\BPO Portal\BPO Portal\App_Data\FinancialControl.mdf ??

Don't do that. Set the path...

First of all, welcome aboard !!

I think you should start with some basic admin book, like the one you get from the official training, to get used to some concepts....

Hi,

you can use the following.

INSERT INTO [Mydb].[dbo].[Departments]

([DeptID]

,[DeptName]

,[Manager])

select 1,'Human Resource','Frank'

union all

select 2,'Management','Franklin'

union all

select 3,'something','something'

Cheers

Hi CrazyMan,

I think that the solution provided by FelixG is the one because you'll have the distinct combination.

Based on the example you provide, you have 3 different values in Age...

Hi,

The answer is no. The jobs that had a start time that fits on the server downtime will not be executed upon the server start.

Cheers

Hi,

If I correctly understood what you want to achieve, I think you can perform that using SQL, which I think will be better than deploying a CLR.

declare @value1 bit

declare @value2...

Hi,

you should deploy it only on the active node, no need to deploy it on every node.

cheers,

Alejandro

Hi there,

the simplest way is replacing this line

insert into @dbs

select name from sys.databases order by name

with this one

insert into @dbs

values ('Name_of_DB')

The nicest way will be removing...

I agree with TheSQLGuru about the lack of information to correctly guide ritesh, but also think that tempdb comments are important because of the same reason: didn't provide us with...

Yeap, follow Chris advice and separate everything. Also consider having 1 datafile in tempdb per processor (this is for avoiding bottlenecks on the tempdb).

If you're server is Win 2003 or...

Hi ritesh.saluja,

also if you're managing tons of inserts per minute, consider creating one or more filegroups on different disks system and put those tables on them. That will reduce IO...

DMC is right, when you connect to the VPN then your default gateway don't know how to route you to the test environment. I suggest you use something like "route...