Hi Matt,

I resolved the problem using merge join.

There is a tutorial:

http://www.mssqltips.com/tip.asp?tip=1322

In order to use merge join, you have to sort the fields you are trying to match.

Can you...

Hi Michael,

Thank you for your repsonse.

I resolved the problem using Dataflow.

Because there is no index set on the ID field, it is taking a long time to match those records...

Thanks everyone,

I have a better understanding now.

I would like to know when we restore a full back up, we restore full LDF if our recovery model is "full". What is...

I found that it is the same deal when it comes to version controlling.

In order to run the package in SQL Server Agent, we have to store our package either...

Hi Greg,

Thanks for your help. I really appreciate that.

I followed the steps from http://www.mssqltips.com/tip.asp?tip=1180 to run my package from a file system in SQL Server Agent. I...

Hi Greg,

Previously, I couldn't manage to run SSIS package from a file location as a SQL Server Agent Job. That's the reason I need to deploy my package to msdb...

Hi,

OK, I found the solution:

1.Store the result to an object variable from table1

2.Use Foreach Loop Container and set object variable as ADO object source variable and map a new variable...

Hi,

I found the ealier discussion

http://qa.sqlservercentral.com/Forums/Topic233916-148-1.aspx

Basically the only version control option is:

1.Using SSMS Integration Services, export the package to file system.

2.Using BIDS, edit the package and save to...

OK.

I need to append to WEB.DB.dbo.USER_LIST table (Server: WEB User ID: WebUser Pwd: WebPass)

Reading records from LOCAL.DB.dbo.USER_LIST table (Server: LOCAL User ID: Local User Pwd:...

Hi Eddy,

Thank you for your opionions. We also started using virtual server instance for DEVSQL.

Regards,

Thanks Brian,

So, your suggestion is to create a different sql login for DBA not a Windows user when we are creating databases and objects.

We used to use 'BUILTIN\Administrators' credentials to...

Hi Michael,

I guess, for 60 Clients and one processor server the "processor type" is cheaper than the "server + CALs type."

If we buy the per processor type license, are we...

Thank you so much for all of you.

That was really helpful.

Hi,

I missed all April's fools. Too bad it's fading. Haha.

Here is the answers:

Will the .NET application cover your license needs or not? Sorry didn't understand this one.

Will the users...

EXEC master.dbo.sp_addlinkedserver @server = N'SERVER\DEV', @srvproduct=N'SQL Server'

GO

OR lets say your 'SERVER\DEV' has a private IP '192.168.0.100' and listening port '1115'

EXEC master.dbo.sp_addlinkedserver @server = N'192.168.0.100,1115', @srvproduct=N'SQL Server'

GO

(use comma between IP and...