Forum Replies Created

Viewing 15 posts - 8,491 through 8,505 (of 13,460 total)

  • RE: drop user tables

    Adiga's code example should be tweaked just a little bit; if that was run in master(where way to many user tables get accidentally created), you could delete some spt^ tables...

    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!

    October 26, 2010 at 5:01 am

    #1242138

  • RE: How to Add Line feed in query result

    xyzxyzxyzxyz123 (10/26/2010)

    Its not working, I have checked it already.

    Any other approach..?

    adding the line feed as Wayne described will work...but the results will not be visible in SSMS in gridmode.

    because SSMS...

    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!

    October 26, 2010 at 4:48 am

    #1242136

  • RE: what is dashboard and scorecards?

    dashboards and scorecards are really close to what you'd intuitively think: reports that provide more of an "at a glance" indicator as to how something is doing(your SQL server, your...

    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!

    October 25, 2010 at 7:11 pm

    #1242007

  • RE: Creating SQL to Oracle Linked Server

    apat (10/25/2010)

    How do I check that oracle client tools are installed on server or not? I am not using sqlplus. After creating a linked server, I'll just use openquery 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!

    October 25, 2010 at 1:12 pm

    #1241855

  • RE: Creating SQL to Oracle Linked Server

    the oracle Client tools ARE installed on the server, right? you did successfully connect from the server's desktop via SQLPlus, right?

    after that, AFAIK, there's three typical reasons for error 7303;...

    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!

    October 25, 2010 at 12:32 pm

    #1241823

  • RE: How to add 2 Temp-table

    reliably? you cannot. to join data from two tables, there must be a join criteria of some kind.

    if you have 5 employees in one table, how do you know which...

    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!

    October 25, 2010 at 12:17 pm

    #1241806

  • RE: How to add 2 Temp-table

    you'll have to provide the linking criteri that shows that an address in one table belongs to the employee in the other;

    and you'll simply use a left outer join 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!

    October 25, 2010 at 10:38 am

    #1241737

  • RE: Creating SQL to Oracle Linked Server

    I edited my saved snippet to have your values;

    change the password and see if this works.

    note that for this to work, the client tools have to have been isntalled...

    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!

    October 25, 2010 at 10:32 am

    #1241735

  • RE: Wierd one..

    krypto69 (10/25/2010)

    if this was parameter sniffing .

    wouldn't I see scans in the execution plan?

    I don't see scans...all seeks..the execution plan matches the one in stage which runs fast..

    I have no...

    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!

    October 25, 2010 at 9:25 am

    #1241674

  • RE: alter tables default auditing - who deleted my columns?

    yes, if not too much time has passed, you can look at the default trace to see who did any DDL chances(ALTER/CREATE/DROP of objects.

    easiest way is via the SSMS GUI,...

    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!

    October 25, 2010 at 6:59 am

    #1241551

  • RE: Alter Hashed login failure

    Marvin that is so weird; i pasted your command to my SQL2005 instance, and it ran without an error;

    maybe it's due to a patch level?

    here's my @@version:

    Microsoft SQL Server...

    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!

    October 25, 2010 at 5:49 am

    #1241511

  • RE: Transfering the Sa password from one server to another

    touching base on this, as Marvin mentioned trouble with this in another thread. I thought the scripting of the hashed password got him where he wanted to be.

    I tested this...

    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!

    October 25, 2010 at 5:41 am

    #1241501

  • RE: Default Instance

    For a default instance, there can be only one. all other additional instances would have to be named instances.

    if your current default is 2008, and you HAVE to have 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!

    October 24, 2010 at 7:30 pm

    #1241392

  • RE: Huge Records...

    hossein what indexes are on the table? the key to performance is having good indexes in place, along with SARG-able WHERE statements(which you seem to have)

    The EntityID column 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!

    October 23, 2010 at 2:37 am

    #1241248

  • RE: Restoring Master database different versions of same service pack

    On a similar thread, Gail Shaw (Gilamonster) reminded us that linked servers and which procedures are scheduled to start when SQL starts are in master, so they need to be...

    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!

    October 22, 2010 at 1:43 pm

    #1241159

Viewing 15 posts - 8,491 through 8,505 (of 13,460 total)