Hello,

As your Job was previously working Okay I was just wondering if the password has just been changed for kwcpwc\datasystm? If not, it may also be worth checking that the...

Hello again,

If you want to use BCP then please see the examples provided at the link I mentioned before.

You could also consider letting Microsoft do the programming for you (if...

Hello,

I don’t believe there is inbuilt functionality to script out the Insert statements for all the data in a Single Table, but there are third party tools which can do...

Hello,

The following link gives the Hardware and Software Requirements for Installing SQL Server 2005:-

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

As you can see from the table “Operating System Requirements”, Windows XP is not supported for the...

Hello,

Did you already take a look at the examples provided by Nigel Rivett, at the following link? Particularly after the heading “Complete control – stored procedures”:-

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

BTW - I’m not...

Hello,

The following article suggests reasons why you may get the error "Shared Memory Provider: No process is on the other end of the pipe".

http://blogs.msdn.com/sql_protocols/archive/2006/07/26/678596.aspx

Also take a look at the comments...

Hello again,

I’ve just remembered … IBM’s product is called DataMirror, and here is a relevant link:-

http://www-01.ibm.com/software/data/integration/dm/

Regards,

John Marsh

Hello,

Do you need the data in SQL 2005 to be current, or are you thinking about a batch process e.g. one data load per day?

I know IBM have a product...

Hello,

I’m not exactly sure what you want to do.

If you need a list of Windows Users in a Windows Group from within SQL Server, you could try using xp_logininfo

e.g....

Hello,

In SSMS, you can use the following option to get rid of the headers:-

Tools, Options, Query Results, Results to Text, Include Column Headers in the Result Set

If you want a...

Hello,

I am not exactly sure where the issue is.

I would expect you could import dates in the DD-MMM-YY format into a DateTime Column without problems.

Once in a DateTime Column (or...

Hello,

Did you already see this SSRS KB Article:-

http://support.microsoft.com/kb/909678

Regards,

John Marsh

Hello,

Hopefully there will be some useful messages in the Event Log which will help identify the issue.

As the SQL Server was previously working though, my first guess would be a...

Hello,

One possibility might to be to create a Day as a Matrix. Each Room would be a Column and each Unit of Time would be a Row. In the underlying...

Hello,

Unfortunately I can’t see the .Net code. The SQL looks Okay though.

Regards,

John Marsh