It is just 17000 records of just one field CustomerID.

I am using everything that people mentioned above for different projects: Linked server with the text driver, OPENROWSET, CLR in 2005...

I can get data into both SQL Server 2005 and MS ACCESS.

For SQL Server 2005:

1. On SQL Server computer install the MySQL ODBC driver from:

ODBC and ADO.NET Driver Download page:

I was able to use my NotesSQL-based Data Source within Excel using Pivot Tables that use Microsoft Query but was not able to use the same data source for Linked...

Andy,

Nice article and very well written!

Hi,

I downloaded NotesSQL too. I was able to create a Data Source. I also added the security in the Data Source by clicking Option button and  Add User and then...

Mohammed,

Did you see this post by Andrew Pfeiffer

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=346725#bm347145

He said that in the maint plans if you have Cleanup task, it resets "Delete...

Irene,

Just in case:

If your directory or folder name contains a space like in Program Files then you should take the path in double quotes like:

dir "c:\Program Files"

Thanks. Forwarded it to other DBAs

Irene,

Try This:

Create

Table #MyTable(MyDir varchar(100))

insert

into #MyTable

execute

master.dbo.xp_cmdshell 'dir C:\'

select

* from #MyTable

Drop

...

Your post proves that you selected a good title! Everyone just read the title, made note that it was released and did not have to open the topic itself 🙂

Thanks for the...

This message normally comes up when the integrated authentication is used the the remote computer can not authenticate your Windows credentials because of the domain trust (or the absence of...

At one of the first Microsoft presentations dedicated to XML many years ago  I sort of tried to make them step back into the reality and asked about performance. There was...

I just tested the above links. It works!!!!

I copied the following from SQL 2000 installation to SQL 2005 installation:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL

Files: scptxfr.exe, scriptin.exe, sqlresld.dll

Then created subfolder Resources\1033 and...

Can you see the old changes at all in Securable?

Back to scripting:

This says:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=168161&SiteID=17

where did scptxfr go?

" I backported scptxfr.exe from a MSSQL 2000 install on another machine...

Did somebody try to play with PIVOT and UNPIVOT in SQL Server 2005? You probably can UNPIVOT the original data and then PIVOT them differently.