OLTP

RE: Returning Multiple Resultsets from an SP

• by Hatim-Ali

• SQLServerCentral

• Reply

Thanks Andy an Don,Andy could you please tell me some code samples or post a link for achieving this using ADO or ADO.NET. Thanks and Regards, Hatim Ali.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-08-01

RE: Simple recovery?

• by FreeHansje

• SQLServerCentral.com

• Reply

Tnx, this sounds promising and I am going to give it a try. Cuurently I am struggling with another problem, related to this 1: see http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=114219If you have an answer to that 1, I owe you.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-05-04

RE: Buffer Cache Ratio and scripts

• by Robert Pearl

• Database Journal

• Reply

Depressing that no one has any ideas about this?  Hasn't anyone been interested in their Buffer Cache Hit ratio?

2004-03-17

RE: Command line utility to create ODBC system data source to SQL

• by mimorr

• Redgate

• Reply

I launch a *.reg file with the information in it.  Below is a sample for Windows 2000.   It adds in the name and the ODBC entry of a SQL Database.  I make my ODBC connections the same name as my database, but you do not have to.  I placed an* where it is optional to use […]

2004-03-15

HELP!!!!!! Need to move sql 7 from NT box to NT box

• by Sean-Noble

• MSSQLTips.com

• Topic

People I need help and seriously quickly I have to move a sql7 server from one NT4 box to a new NT4 box. Just one little problem. I know jack didly nothing about sql and I mean absolutly nothing. Somehow somewhere I need a detailed step by step guide on how to do this without […]

2004-03-11

RE: Line Drawing Extended ASCII characters in Text Field

• by Dave-Bodenheimer

• MSSQLTips.com

• Reply

Thanks Frank,  I'll check.  I feel so stupid asking this question because it seems so easy, but I'll be darned if I can figure it out!

2004-03-01

RE: Syntax to write to file

• by gljjr

• SimpleTalk

• Reply

Since you need to do this monthly the best thing to do would be to set up a DTS package and then have a SQL Job run the package once a month or do as Steve suggested and have the SQL Job start osql in an operating system command and use the switch to use […]

2004-02-13

RE: Writing to text files within a SQL Stored Proc

• by James Travis

• SQLServerCentral.com

• Reply

Yes you have to use the OA ole creation method to open filesystem objects see BOL quote: How to create an OLE Automation object (Transact-SQL) To create an OLE Automation object Call sp_OACreate to create the object. Use the object. Call sp_OAGetProperty to get a property value. Call sp_OASetProperty to set a property to a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-11-21

RE: select and lock next key value

• by Johan Bijnens

• SQLServerCentral.com

• Reply

create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it. That is if you want to have a key sequence. You could also use uniqueidentifiers. Then you can just generate them at clientside. They are considered to be […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-08