Hello,

Are you familiar with Table Joins? I would suspect Joins would be the basis for your solution.

For example if you needed a report that contains one record per Store with...

Hello,

I just wanted to check if my understanding is correct – are you planning to separate the user data into its own DB and upgrade to SQL 2005 at the...

Hello again,

If you are connecting to a Named Instance of SQL 2005 and the SQL Browser is not running then you must supply the Port Number of the Named Instance...

Hello,

I don’t know of any way of changing the port of the SQL Server Browser Service from 1434, but I am wondering why you would want to anyway?

Your post just...

Hi Trish,

One more thought - when you execute the SP are you signed onto the SQL Server with a SQL or Windows Login?

From my understanding, if you use a SQL...

Hello,

Might be worth trying with the alternate driver suggested in this article:-

http://omensblog.blogspot.com/2008/05/opendatasource-or-openrowset-linked.html

Regards,

John Marsh

Hello,

Does the data that you want to insert already exist in electronic form e.g. in a Flat File, another DB Table etc, or do you have to manually type it...

Hello Hassan,

“select *from @srvname.master.sys.sysdatabases” won’t work.

You could use dynamic SQL for this i.e. build the Select statement inside a string variable and then execute it.

Regards,

John Marsh

Hello Sanjeev,

Where do you see the dates in different formats i.e. is it in a screen displayed by an application? If (in SSMS) you run the same Select statement against...

Hello,

I assume the dates are being stored in DateTime or SmallDateTime data types? If so, the Books Online topic “Date and Time (Transact-SQL)“ describes how SQL Server internally stores dates.

I...

Hello Hassan,

Have the Linked Servers already been configured?

If so, the main work has been done. You can gather data from Tables and Views on the Linked Servers simply by using...

Hello,

It seems you do not have one already, so you (urgently) need to assign a strong password to the SA Login.

Best practice is to use Windows Integrated Security i.e. add...

Hello,

Naturally I don’t know what your SSIS package is doing, but if it needs access to any Windows Resources then an OS security update may well affect it.

Assuming that your...

Hello again,

In that case I would guess it is a permission on a specific resource that the kwcpwc\datasystm account is missing. As you mentioned that the job was working well...

Hello,

Is it possible that somebody e.g. a SQL Server Administrator, has recently changed the query governor cost limit?

I am just wondering why your job was working before, and not now....