Forum Replies Created

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

  • RE: Eliminating Cursors

    I like that idea, because it gets us cleaning the data on a set basis.

    But, not to be to persistent I hope, but my point is that in a database...

  • RE: Eliminating Cursors

    May I weigh in here, and forgive my inexperience, but I keep running into this one.

    Seems weird to me that one would have all these criteria for valid data stored...

  • RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied

    In your post of the code that finally worked (using the SQL connection instead of an OLDEB connection, and SQL datat types instead as well), you said that the code...

  • RE: Why does Db attach Read Only?

    As I said, "If I go to file properties, security tab for the db in question, I cannot locate the 'Netwrok Service' account to add permissions. It's just not there."

    However,...

  • RE: SQL with Host Variables in Visual Basic

    If you're using VB6, you need to look at the File System Object, which has the code necessary to:

    1) Point a variable at the folder

    2) List the files in the...

  • RE: Can I SELECT FROM a Stored PROC?

    Thanks. I don't think I really consider using Views enough. I will reconsider using them. Especially in cases like this. I'm not clear on how to getthe parameter to the...

  • RE: Can I SELECT FROM a Stored PROC?

    Why is a view much more effective?? (I know, that's off topic)

    In addition, I need to parameterize it since I do not always seek out the same 'role' that the...

  • RE: Can I SELECT FROM a Stored PROC?

    The proc I want to use is a variation of the asp.net membership proc that determines what members are in what roles ('aspnet_UsersInRoles_GetUsersInRoles'), and the complication is that the roles...

  • RE: Converting app from Coldfusion to SQL Server 2005

    Well, I know how to do it in asp, and asp.net. I could take a crack at reading the ColdFusion code but I could easily make some bad assumptions.

    I think...

  • RE: Converting app from Coldfusion to SQL Server 2005

    Well, don't know how you can do that from inside SQL server, and I suspect that if you use the CLR to do it, it would be a real heavyweight...

  • RE: Converting app from Coldfusion to SQL Server 2005

    Whew! I think you're past my expertise (usually not tough to do!). I can't really see how you can take a web app and jam it into SQL server, which...

  • RE: Converting app from Coldfusion to SQL Server 2005

    I don't know ColdFusion, but it seems to me that the code you showed runs as a web application, not inside a database. Thus you would be more likely to...

  • RE: Multiple Keyword search

    Maybe this is what you need to know:

    In SQL Server Management Studio, select your database, got to Progammability..Stored Procedures... right mouse, 'new stored procedure'.

    In the tab that opens, note that you...

  • RE: How do you handle halfwit developers?

    Developers work on one row at a time because that's what the humans who work in front of the computers do... one row of one order at a time.

    Doesn't mean...

  • RE: Do I need the ''''sa'''' account?

    OK, looks like I got some good advice. Thanks!

    Summary:

    1) Can't disable or rename 'sa'

    2) Continue to use a strong password for 'sa' but change it frequently

    3) Get the VPN going...

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