Monday, May 13, 2013

[MS SQL Server] Export table in to txt

[MS SQL Server] Export table in to txt

Export table in to txt

Posted: 13 May 2013 02:51 AM PDT

dear Gurus,I want to export data in table to txtSELECT [StatBeginTime] ,[MDASum] ,[BureauName] ,[MDA] FROM [kpidb].[dbo].[t_MDA_1]the result :2013-05-13 00:14:00.000 290 bjm 2616512013-05-13 00:29:00.000 226 bjm 2037672013-05-13 00:44:00.000 174 bjm 15730how to process so can create file txt in c:\\ directory ??? many thanks

Minimum setup for SQL Server Express application

Posted: 13 May 2013 02:50 AM PDT

We need to set up remote desktop (or laptop) computers (not in network) with a copy of the master database that is accessed from a .NET windows application.I was planning to install SQL Server Express (2008 R2) runtime on each remote computer.What is the minimum I need? Can I install a few DLLs and point it to a copy of an .mdf file with the connection string? Is it possible to point SQL Server Express to the database file without having to install the SSMS on each computer?

Performance Counters Scripts

Posted: 12 May 2013 11:38 PM PDT

Can you please any body give me all Performace Counters script, which generate report including all performance counters in SQL Server 2005.Performace COUnters Ex:CPU,Physio IO,Disk Reads and Writes,Buffer Cache Hit Ratio,Blockings,Dead Locks..etc.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog