Forum Replies Created

Viewing 15 posts - 11,611 through 11,625 (of 13,460 total)

  • RE: Retrieve column headers for INFORMATION_SCHEMA

    {edit}ok, what are "column ?Headers...that's what i'm not understanding.

    maybe I'm oversimplifying, but since the table_name exists in information_schema.columns, why not just select directly fromt here?

    select * from

    INFORMATION_SCHEMA.COLUMNS

    where table_name ='mytable'

    what...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 11, 2009 at 7:34 am

    #942131

  • RE: UPDATE question

    just to be clear, an UPDATE statement will affect EVERY row in a table, UNLESS you limit it with a WHERe statement; This is one of the cool principals of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 11, 2009 at 7:00 am

    #942095

  • RE: Is there any ppl knows that which service pack contains hotfix Bug #: 50000895 (SQL Hotfix)

    never installed the hotfix, but i found this:

    http://support.microsoft.com/kb/934396

    Note The file version of the Sqlvdi.dll file in this hotfix is 2000.85.2102.0. The file version of the Sqlvdi.dll file in hotfix 935465...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 8:09 pm

    #941773

  • RE: Multiple VB2008 field updates

    At least in my DataAccess, which is based on MS application blocks, in .NET, the adapter uses negative numbers for new rows...-1,-2, etc. for any of the typed data sets.

    when...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 8:02 pm

    #941772

  • RE: Trigger Vs Stored Procedure

    Triggers are just event driven stored procedures. functions are limited versions of stored procedures, right?

    for any identical code, all three should perform at the same speed, same execution plan, same...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 1:51 pm

    #941635

  • RE: How to prevent users from connecting to DB using MS-Access?

    with an application role, the end users will not know or need the password....the IMS application would login using that instead of passing their Windows credentials...Like Jack said, this depends...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 1:24 pm

    #941596

  • RE: How to prevent users from connecting to DB using MS-Access?

    stating the obvious, you've got to disable their access.

    Here's how:

    from Enterprise Manager, right click on the server, and expand the "Security Folder" so you can see "Logins"

    You might see BUILTIN\Administrators...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 1:10 pm

    #941582

  • RE: Convert Integer Date to DateTime

    ok you'd get that eror if there was a weird value in

    can you run this and see what the last run date value is?

    [font="Courier New"]SELECT @@servername AS [Server],

    J.name...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 7:56 am

    #941229

  • RE: Stored procedure error

    does the stored procedure AxSP_Adhoc_PerformConsistencyCheck exist in the master database, or the default database of the user AOANHSS\sqlnashrep?

    if it exists in master, but the default database for AOANHSS\sqlnashrep is "DevDB",...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 5:27 am

    #941107

  • RE: cannot reassign dbo to another user

    because the backup came from your supplier, and not from your server, the user "eu\genetica" is "orphaned...that is, every server in the work may have a user named "Bob", bu...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 5:20 am

    #941103

  • RE: how to remove a foreign key for a table in sql server 2005

    sp_help the table, and find the name of the Foreign key you want to drop.

    issue the drop command like this:

    sp_help gmact

    alter table gmact drop constraint FK__GMACT__AACCOMPLT__66960AE6

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 5:10 am

    #941097

  • RE: Identifying unused tables and stored procedures since last six month

    You can't automatically do it, some decisions have to be made. Also remember a functionality may exist that would use a table in the database, but just hasn't been used...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 10, 2009 at 5:02 am

    #941093

  • RE: Import/Export Triggers from pgsql to MSSql server 2005

    your views and indexes should port right over, but triggers,procedures and functions will need to be hand edited; there just isn't an easy way to move those over, sorry.

    Are you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2009 at 9:51 pm

    #940952

  • RE: How to remove Reporting Services?

    yes; each service can be uninstalled, or installed after the normal database services install.

    Just like any other program, go to add/remove programs in teh control panel, find SQL 2005, adn...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2009 at 6:45 pm

    #940935

  • RE: Simple SELECT for Inoices with certain Items

    duplicate post...continue to follow the thread here:

    http://www.sqlservercentral.com/Forums/Topic653232-149-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2009 at 2:40 pm

    #940838

Viewing 15 posts - 11,611 through 11,625 (of 13,460 total)