Forum Replies Created

Viewing 15 posts - 841 through 855 (of 1,315 total)

  • RE: Stored Procedures - what have they done??

    If you have text in red (which means it is a quoted string) that looks like T-SQL code, the stored procedures are probably using dynamic SQL.  This means they are...

  • RE: Don''''t allow programs to connect remotely to sql server

    Apparently you could set up a trace table in SQL Server 7.0 using xp_trace_addnewqueue, but not in SQL 2000 with sp_trace_create.  I don't know how Profiler does it.  Maybe you...

  • RE: Don''''t allow programs to connect remotely to sql server

    I've never tried this, but a quick search on MSDN for "SQL Server 2000 login auditing" turned up a lot of links, including this article that discusses enabling C2 auditing...

  • RE: osql

    It's obvious you're too young to have been using computers in the pre-Windows era on Flintstone-style Teletypes.  Lucky you.

    You can use the ECHO command in a bat file to display...

  • RE: problem with a view, its not bring back rows with null in it

    Using FULL JOIN will include rows where the join field is NULL, but they will be in different records.  Assuming tables A and B are joined on field XYZ and...

  • RE: Don''''t allow programs to connect remotely to sql server

    Another good condition for the WHERE clause would be "and hostname <> @@servername" to be extra careful not to kill a server process or scheduled job.

    This assumes users can't just...

  • RE: Don''''t allow programs to connect remotely to sql server

    Look at the program_name field in the results of sp_who2.  You will see "SQL Query Analyzer", "SQL Query Analyzer - Object Browser", "MS SQLEM", and/or "Microsoft SQL Server Management Studio"...

  • RE: Don''''t allow programs to connect remotely to sql server

    There has to be a login available for the application to connect to the server, and it has to have access to a database, before it can use an application...

  • RE: osql

    If you want to run something too big for the command line, save it in a script file and use -i {inputfile} instead of -q {query}.

    As an alternative to -i...

  • RE: backup store procedures....

    You can script the stored procedures to a file, then back that up.

    Right-click on a database in Enterprise Manager or Management Studio and look for "Generate Scripts...".  Use the formatting...

  • RE: Tax Day

    I may have heard of it on talk radio, or on the internet, about two years ago.  The people behind it started working on it about 20 years ago, and have done...

  • RE: Tax Day

    Your entire paycheck is part of a company's cost of doing business, but the FICA matching contribution is part of their labor budget so the easiest thing to do might...

  • RE: BUG:SQL Server 2000 Enterprise Manager????

    I was able to reproduce this behavior in Enterprise Manager, but not with Query Analyzer's Object Browser or in SQL 2005 Management Studio.  I am guessing that the SQL-DMO code...

  • RE: SQL Maint Utility

    You are correct, sqlmaint uses DBCC DBREINDEX.

    I believe it was DBCC REINDEX up to version 7.0, then renamed DBREINDEX in SQL 2000.  In SQL 2005 it's ALTER INDEX (although DBCC...

  • RE: programming

    In addition to the argument over where business logic belongs, there is the issue of security.

    Data can be secured easily if all access is through views and stored procedures (i.e....

Viewing 15 posts - 841 through 855 (of 1,315 total)