Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 3,613 total)

  • RE: Is T-SQL enough to be a valuable Yukon DBA?

    The MS Press book SQL Server 2000 with XML has a whole chapter on enabling your SQL Server to allow queries and updates via HTTP.

    It then goes on to say,...

  • RE: Reaching the Outer Limits

    All hail the GUID, thats what I say!

  • RE: Reducing Round Trips

    Great idea, providing you are using ADO.

    Being a SQL Server guy it is very easy to get into the Microsoft mentality. JFDI methodology.

    We use a variety of Web Content Management...

  • RE: Querying XML files using SQL 2000

    Books on line says "A parsed document is stored in the internal cache of SQL Server 2000. The MSXML parser uses one-eighth the total memory available for SQL Server. To...

  • RE: Snapshot Replication

    I use snapshots when I need to duplicate a live environment for testing purposes.

    1. Receive change request.

    2. Snapshot the live to a development machine.

    3. Test on the development machine.

    4. Make...

  • RE: Querying XML files using SQL 2000

    Oh the embarrassment, thanks to Carsten Dauguaard for spotting it.

    exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stdoc

    should be

    exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stXML

  • RE: Querying XML files using SQL 2000

    Oh the embarrassment!!!!

    Thanks to Carsten Dauguaard for spotting it.

    In the code for the stored procedure

    exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stdoc

    should be

    exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stXML

    This is what you get when you...

  • RE: SQL Server 2000 Post SP2 Patch Released

    If these critical fixes are not part of SP3 then would you recommend holding off on SP3 and wait for SP4?

  • RE: How to save FORXML result into a text parameter

    What are you going to do with that text parameter after you have retrieved it?

    Why not loop through the returned recordset and build up the string in your app and...

  • RE: Beware to the System Generated Constraint Name

    I DO name my constraints.

    If SQL needs an index and there isn't one available it creates its own.

    Sometimes an index is not appropriate but SQL may decide that it needs...

  • RE: Stored Procedure Defintion

    If all you want is a list of names simply run

    SELECT Name FROM SysObjects WHERE TYPE='P'

    P = Stored Procs

    V = Views

    TR = Triggers

    If you want the actual definitions then try

    SELECT...

  • RE: dbo user cannot be found

    I'm willing to be that the dbo user does not have an associated login.

    Use sp_ChangeDbOwner '<<whatever login you want>>' within the database and the dbo user should be fine.

    I often...

  • RE: Review: MSSQLCrack

    Although these utilities are useful I felt a chill go down my back the first time I saw one of these things working.

    I used the toolkit from http://www.lostpasswords.com on NT...

  • RE: Beware to the System Generated Constraint Name

    I had a table called Tbl_CommenceDownload and noticed that I gained an index called tTbl_CommenceDownload.

    I attempted to drop this and got the standard message that tells you that you are...

  • RE: Beware to the System Generated Constraint Name

    I thought this at first, however it is not as simple as the naming convention.

    Not all system indices start __WA etc.

    The way I get around it at present is to...

Viewing 15 posts - 3,556 through 3,570 (of 3,613 total)