Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 13,460 total)

  • RE: Cursor stopped working after working for a while. Now only inserts first record into the table

    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!

    July 12, 2012 at 7:20 am

    #1512042

  • RE: Changing SQLserver default port

    how many instances of SQL are installed on your dev machine?

    could it be that another isntance is answering the default port of 1433?

    What i'm saying is that maybe you changed...

    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!

    July 12, 2012 at 6:29 am

    #1512009

  • RE: Changing SQLserver default port

    if the SQL browser service is running, any connections that ask for the server will be directed to the proper port.

    if you stop the SQL Browser service, then the port...

    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!

    July 12, 2012 at 6:11 am

    #1511995

  • RE: stored procedures not saving temp or local file

    a table created inside a procedure is destroyed when the procedure completes.

    if you want to a proc to load your data, you have the following options:

    1. have the same procedure...

    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!

    July 12, 2012 at 5:47 am

    #1511989

  • RE: sys.columns X syscolumns

    JoseACJr (7/12/2012)

    Hi everybody,

    I will create an application to list the columns of my database, what the difference between sys.columns and syscolumns ?

    They are not tables? which tables these views...

    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!

    July 12, 2012 at 5:39 am

    #1511986

  • RE: Find db's that has the user

    and a code example of what Jason was talking about:

    sp_msForEachDB 'select ''?'' AS DatabaseName,

    ...

    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!

    July 11, 2012 at 2:59 pm

    #1511814

  • RE: Need help with Distributed Query with Linked Servers

    if you leave the schema name to auto resolve, does it work, like this?

    SELECT * FROM [LINKSERVER_1].[ActualDBName]..DAYPART

    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!

    July 11, 2012 at 12:22 pm

    #1511725

  • RE: Get Column name & table name from value

    deprecation?

    last i heard, the views were there to stay, but could be changed;

    some article i read said any changes would be things like adding columns to the end of the...

    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!

    July 11, 2012 at 11:55 am

    #1511717

  • RE: Get Column name & table name from value

    the opposite question for me really, is what advantage would there be to use the information_schema instead of the sys tables?

    typically there's more information available in the SQL specific...

    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!

    July 11, 2012 at 11:43 am

    #1511708

  • RE: Get Column name & table name from value

    here's what i use , a procedure i built called sp_UglySearch.

    since you are searching every table/column for text, this is slow, and any tables with a Million rows are going...

    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!

    July 11, 2012 at 6:19 am

    #1511477

  • RE: Get Column name & table name from value

    i took over a screwed up database like that once; the table names and column names had been obfuscated, i guess in order to protect someones proprietary schema; they took...

    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!

    July 11, 2012 at 6:10 am

    #1511469

  • RE: DBCC CheckDB Errors 8992, 8954, 8989

    sounds like two things: this database was upgraded from SQL 2000, and someone had ran "EXEC master.dbo.sp_configure 'allow updates', '1'", and deleted the row from sysobjects directly, without deleting the...

    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!

    July 10, 2012 at 2:49 pm

    #1511218

  • RE: SQL error on scaler variable

    CREATE PROCEDURE [dbo].[DR_Premier_PO_O]...

    you are just missing the word create; after that my syntax issues went away.

    i got 4 errors total, and only the last matched your error.

    Msg 156, Level 15,...

    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!

    July 10, 2012 at 1:51 pm

    #1511187

  • RE: How to know the SQL objects allocations among the primary and secondary files of a particular database

    i think joining sys.partitions gives me which partitions the tables or the indexes reside;

    most of the other objects (procs, views, functions triggers are just compiled code, and their definitions...

    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!

    July 10, 2012 at 1:46 pm

    #1511184

  • RE: How to check if column has set to identity??

    one way is to look at sys.columns, which has an is_identity indicator:

    select

    object_name(object_id) as TableName,

    name As ColumnName,

    is_identity

    from sys.columns

    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!

    July 10, 2012 at 12:50 pm

    #1511143

Viewing 15 posts - 5,206 through 5,220 (of 13,460 total)