Forum Replies Created

Viewing 15 posts - 9,076 through 9,090 (of 13,460 total)

  • RE: Block Users from using sql server query analyzer

    the answer is yes and no.

    once I have a username and password, I'm good to connect with anything i can get my grubby fingers on...SSMS, a program i write, Access,Excel,...

    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 9, 2010 at 12:17 pm

    #1190980

  • RE: is there really no way to do this? turn rows into columns?

    great job on providing the data we need to test.

    rows to columns and columns to rows is probably the single most asked question on the forum; i bet there are...

    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 9, 2010 at 11:38 am

    #1190965

  • RE: SQL mails in outlook template oft

    I don't think that will not work. Outlook.exe accepts no exposed command line arguments, so you could not automate it like that, i think.

    what's wrong with opening a new email...

    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 9, 2010 at 11:00 am

    #1190940

  • RE: Linking databases from Different servers

    did you create linked servers to them yet?

    once the link exists, it's nothing more than referencing them with a 4 part name:

    SELECT * FROM LinkedServerA.databasename.dbo.TableA myAlias1

    LEFT OUTER JOIN

    LinkedServerB.otherdatabase.dbo.TableB myAlias2

    ON myAlias1.Id...

    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 9, 2010 at 10:53 am

    #1190933

  • RE: BCP command fails on SQL 2008

    Shree-903371 (7/9/2010)

    Its givving Query Engine Error. Its running fine on my system. Just when i publish it on the server its failing.

    http://aspadvice.com/blogs/rjdudley/archive/2005/05/13/2589.aspx

    his first reason is my first guess...either the db...

    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 9, 2010 at 7:36 am

    #1190801

  • RE: Using Triggers to update data.

    ugg... i'm thinking that the same trigger in multiple databases will cause locking as soon as DB1 updates DB2 and fires the DB2 trigger, which in turn wants to update...

    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 9, 2010 at 6:29 am

    #1190751

  • RE: Restoring a database

    Toric what you want to do is to look in the scripts section here on SSC, and find some of the examples that script out roles and users, and their...

    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 9, 2010 at 6:20 am

    #1190740

  • RE: Regarding time stamp retrieval

    Jim is right, there is no hidden field anywhere that tracks WHEN an item was inserted or updated. if you don't have a column for it, you'll have to add...

    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 9, 2010 at 6:13 am

    #1190731

  • RE: Using Triggers to update data.

    thanks for the explanation!

    yeah...you can use dynamic SQL in a trigger to do what you want, but if you have 50 databases, don't you need the same trigger on 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 9, 2010 at 6:06 am

    #1190726

  • RE: Updating all my 1000 procs

    well, before you go and do that, read this thread, where the original poster is having trouble because his procs don't work the same way anymore when TRY...CATCH is added.

    Try...

    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 9, 2010 at 5:53 am

    #1190719

  • RE: Using Triggers to update data.

    wouldn't it fail anyway if your table doesn't exist in the database as you are going thru them with a cursor?

    if you explain your process, we might be able to...

    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 9, 2010 at 5:38 am

    #1190708

  • RE: Generate Script options

    Oh man I hated that too;

    it's not obvious, but under Scripting options, change "Include IF NOT EXISTS Clause" from true to false...then all your objects will script normally instead 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!

    July 9, 2010 at 5:35 am

    #1190707

  • RE: Using Triggers to update data.

    you need to change it to refer to each database individually, and use a full three part naming convention to get to each database, I think:

    INSERT INTO Production.dbo.AuditTable ....FROM INSERTED

    INSERT...

    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 9, 2010 at 5:29 am

    #1190704

  • RE: I reduced my poor performing query from 10 min to 2 now if I could only use it

    dan don't forget a CTE is just a named sub select...you can move the CTE equivalent into the query as a sub query.

    ;with CTE AS (select other stuff...)

    select stuff from...

    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 8, 2010 at 2:38 pm

    #1190502

  • RE: "The multi-part identifier could not be bound" Error... Need help ASAP

    a perfect example of why you should not use the old ansi syntax, and only the new ones with the JOIN keyword.

    your query never connects the table FWXProductClassification to anything...

    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 8, 2010 at 1:56 pm

    #1190480

Viewing 15 posts - 9,076 through 9,090 (of 13,460 total)