Forum Replies Created

Viewing 15 posts - 11,911 through 11,925 (of 13,460 total)

  • RE: Urgent: Problem with Linked servers using Kerberos

    just checking the basics....are you using a full path in the query, for example

    select * from ServerB.DbName.dbo.Employees where Ename='Bob'

    could you please show a sample query, where a table exists in...

    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!

    November 6, 2008 at 5:00 am

    #894767

  • RE: Pls, how can I give a user exclusive rights to dbase? I can only access with sa...

    when you restore a database on a DIFFERENT server, you get something called "orphaned users" ; remember a database with a login "Bob" on my server is not the 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!

    November 5, 2008 at 6:16 pm

    #894604

  • RE: Notes

    less space? even the smallest servers today have at least half a terabyte or so of space if not more, and you are worrying about a miniscule amount of space,...

    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!

    November 5, 2008 at 11:14 am

    #894440

  • RE: Trigger that uses a Parameter with Inserted/Deleted

    if you think you need a cursor in a trigger, you're always, and i mean ALWAYS, looking at the problem wrong.

    one of the new feature sin SQL2005 is the COLUMNS_UPDATED...

    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!

    November 5, 2008 at 10:09 am

    #894387

  • RE: Notes

    if you decinde you need separate tables for notes, then

    if you have three tables that need notes, I'd really recommend three notes tables, all with enforced FK's instead; it saves...

    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!

    November 5, 2008 at 10:03 am

    #894381

  • RE: DISTINCT AND COUNT

    SELECT DISTINCT [Name],[Date Of Birth]

    FROM [zzWembley WIC 2ND QTR 2008]

    I get 2664 records with one record null

    this implies that there are people who have the same name, but 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!

    November 5, 2008 at 9:53 am

    #894366

  • RE: mdf file is not updated

    the mdf file is open and held open by sql server....only by stopping the SQL Server service would the file date get refreshed....changes happen, but the file is never "closed"...

    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!

    November 5, 2008 at 6:50 am

    #894202

  • RE: Clear Database Engine Server Name drop down

    I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

    mine has a list...

    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!

    November 5, 2008 at 6:46 am

    #894198

  • RE: Reverse engineering help needed

    if you are lucky, you can hope for a couple of design standards that could make it easier.

    IF you can assume that FK columns have the same name as it's...

    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!

    November 5, 2008 at 6:22 am

    #894182

  • RE: SMTP authentication using sp_send_cdosysmail?

    the CDO object has the ability to send the SMTP user And password, but the default procedure

    sp_send_cdosysmail does not have parameters for it;

    if you don't have the sp 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!

    November 4, 2008 at 7:57 am

    #893636

  • RE: Sending mails from SQL 2005

    do not cross post the same question in different forums.

    follow the thread here:

    http://www.sqlservercentral.com/Forums/Topic596429-146-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!

    November 4, 2008 at 7:42 am

    #893627

  • RE: Sending mails from sql 2005

    do not cross post the same question in different forums.

    follow the thread here:

    http://www.sqlservercentral.com/Forums/Topic596429-146-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!

    November 4, 2008 at 7:41 am

    #893624

  • RE: INSERT INTO table with an NOT NULL column ?

    as an example, I'd forget trying to restart the object number as restarting at 1 with a category break, and just generate a number based on Category and item

    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!

    November 4, 2008 at 7:28 am

    #893609

  • RE: INSERT INTO table with an NOT NULL column ?

    i don't really like the structure of your table; you are really assuming that you will be inserting the header "T shirts" at the same time as all it's...

    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!

    November 4, 2008 at 7:12 am

    #893600

  • RE: Identity column value should not be increased if there's pbm in insertion of record.

    can you change the way the data gets inserted? if an application is trying to do an INSERT, can you make it call a stored proc instead?

    what happens if 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!

    November 4, 2008 at 6:25 am

    #893572

Viewing 15 posts - 11,911 through 11,925 (of 13,460 total)