Forum Replies Created

Viewing 15 posts - 46 through 60 (of 161 total)

  • RE: The September 2008 Car Update

    Heh. Small world. I lived in Lewisville and Flower Mound for four years. My wife went back through there a few years after we'd moved and the place had exploded...

  • RE: The September 2008 Car Update

    The Springs is a bit higher, and we lived smack against the base of the mountain, but I don't think the weather patterns would be *that* different. How far out...

  • RE: The September 2008 Car Update

    From your article, and I quote:

    Winters are relatively short here in Denver

    Which Denver are you living in??? I lived in Colorado Springs for two years. It snowed over Memorial weekend,...

  • RE: Tivoli Storage Manager and backups

    We use Tivoli as our primary backup and restore system. What I found is that the Tivoli system can interfere with the normal database processing (soaking up the CPU and...

  • RE: My Sons first birthday this weekend

    A big cake with chocolate icing and lots of pictures! Stuff like this comes in real handy when they're 16 and getting interested in girls!!

    😀

    Steve G.

  • RE: Excel with Stored Procedures

    Sorry, I wasn't clear in my previous post - how do you query SQL Server from Access using this sort of technique?

    Steve G.

  • RE: Excel with Stored Procedures

    I do realize that this is just asking for trouble, but how do you do the same thing in Access? 😀

    Steve G.

  • RE: Openrowset on an excel 2007 file

    I think the "linked server" message is a bit of a red herring. SQL Server is simply trying to tell you that it can't connect to the 'remote' data source....

  • RE: Openrowset on an excel 2007 file

    Dumb question: where is the excel spreadsheet? Remember, the drive reference "d:\import.xlsx" is relative to the server, not to the computer where you're running the query.

    Steve G.

  • RE: Problem in SSIS package from Lotus notes to SQL server 2005

    Try using OpenRowSet with a DSN-less connection string instead of going through ODBC to get to the Notes db.

    Don't know if this will work, but it might avoid the managed...

  • RE: next row Number

    If you do things this way, you will most definitely have problems. If you have more than one connection, you can have both connections get the same value for the...

  • RE: next row Number

    create table #t (

    i int identity(1,1),

    a varchar(10),

    b varchar(10)

    )

    go

    alter proc t_insert(@b varchar(10))

    as

    begin

    begin tran;

    ...

  • RE: Cannot write into tables using ODBC

    Do these tables have primary keys defined in SQL Server? I've seen this where ODBC will default to read-only cursors for tables w/o primary keys.

    Steve G.

  • RE: ASP and SQL Coding Help

    There's a number of things that can be done. Perhaps the easiest is to not use dynamic SQL. That is, move the SQL statements to a stored procedure and pass...

  • RE: ASP and SQL Coding Help

    That does help things a lot, but I think that security oughtn't be ignored (or best practices either, for that matter), even for internal applications. 😀

    Steve -kicking in his...

Viewing 15 posts - 46 through 60 (of 161 total)