Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 13,460 total)

  • RE: Update local table from linked server (Excel file)

    if you've got the linked server up and running, that's 99% of it;

    the rest is just syntax.

    something like this is how you update from another table...and it doesn't matter if...

    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!

    December 6, 2012 at 11:40 am

    #1566293

  • RE: Login Auditing

    that documentation here is a little inferred ("the log" means sql error log), but "you mean like this one:

    http://msdn.microsoft.com/en-us/library/ms175850(v=sql.90).aspx

    How to: Configure Login Auditing (SQL Server Management Studio)

    SQL Server 2005 Other...

    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!

    December 6, 2012 at 9:40 am

    #1566246

  • RE: Attach to existing database?

    looks like poorly worded documentation to me.

    the way i read that is that they mean this instead:

    ATTACH the database connect the application to that database and it the application will...

    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!

    December 6, 2012 at 9:18 am

    #1566234

  • RE: Copy Dynamic List of Tables to Another Server

    ok this seems to have everything for creating a linked server to an Azure Cloud; what kind of cloud server are you using?

    http://blogs.msdn.com/b/sqlcat/archive/2011/03/08/linked-servers-to-sql-azure.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!

    December 6, 2012 at 9:08 am

    #1566227

  • RE: Copy Dynamic List of Tables to Another Server

    DDL structure and the data both, or just the DDL?

    hierarchy of the tables due to FK's need to be in the mix there somewhere as well, if we are Creating...

    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!

    December 6, 2012 at 9:06 am

    #1566226

  • RE: RML files

    looks important:

    http://www.fileinfo.com/extension/rml

    i think those files are used by autocad and are drawings of something;

    the server might not have autocad installed, so there's no application to open them by default, but...

    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!

    December 6, 2012 at 8:32 am

    #1566206

  • RE: SET IDENTITY_INSERT [dbo].[tblTransactions] ON

    no, like the code below..you don't use identity_insert unless you have to.

    you didn't answer my questions:

    why do you have to enter an almost identical row into the same table WHERE...

    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!

    December 6, 2012 at 7:14 am

    #1566163

  • RE: SET IDENTITY_INSERT [dbo].[tblTransactions] ON

    briancampbellmcad (12/6/2012)

    So is there a way of simply inserting a new record into a table with a PK via a trigger?

    yes. don't reference the identity column,and let the pk automatically...

    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!

    December 6, 2012 at 7:08 am

    #1566156

  • RE: SET IDENTITY_INSERT [dbo].[tblTransactions] ON

    nowhere in the trigger example you posted is the IDENTITY_INSERT command being used.

    can you show us the code you are using?

    i would have expected it to look like this:

    ALTER TRIGGER...

    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!

    December 6, 2012 at 6:32 am

    #1566133

  • RE: Adding Non-Cloustered Index differs no. of rows returned in resultset

    Suresh Arumugam (12/6/2012)

    Hi,

    I was trying to tune a particular SQL query which use to take more than 10 seconds to return data. Added much needed Non-Clustered Index for one...

    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!

    December 6, 2012 at 6:07 am

    #1566126

  • RE: Web enabled SQL Server Management Studio?

    samalex (12/5/2012)

    pchirags (12/5/2012)

    http://www.mssqltips.com/sqlservertip/1311/web-based-database-administration-for-sql-server/

    Nice Link to go through..

    Thanks

    I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which isn't valid. ...

    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!

    December 5, 2012 at 3:16 pm

    #1565945

  • RE: Generate invalid dependency object list in SQL Server 2008

    i've got this script i posted here on SSC multiple times that seems to do a nice job for me;

    for Invalid Objects, it's not like oracle, where there is a...

    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!

    December 5, 2012 at 2:07 pm

    #1565912

  • RE: SEQUENCE Problems

    well so far, i haven't been able to get a duplicate in my limited testing;

    i was thinking that maybe a developer had a transaction open, went to lunch, and then...

    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!

    December 5, 2012 at 2:03 pm

    #1565910

  • RE: Need help getting totals by ZipCode

    you can use a technique using SUM(CASE... to get subtotasl;

    you'll have to construct the multiple case statements to match your descriptions, i think.

    here's a prototype based on the query 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!

    December 5, 2012 at 12:05 pm

    #1565882

  • RE: List of Database Naming Convention Decision Points

    we use this one at our shop:

    primary key and foreign key column name must contain name of the table...ie tbCity has tbCityID as it's PK, and all foreign key 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!

    December 5, 2012 at 10:16 am

    #1565847

Viewing 15 posts - 4,261 through 4,275 (of 13,460 total)