Forum Replies Created

Viewing 15 posts - 5,971 through 5,985 (of 13,460 total)

  • RE: How can we find out if a particular database is the defualt database for any login ?

    Joy Smith San (2/7/2012)

    Hi All,

    I connected to one of the server and and detached one database.

    After that I was not able to do anything is SQL Server as the detached...

    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!

    February 7, 2012 at 4:15 am

    #1443651

  • RE: MySQL Linked Server Problem

    Jared may be right...start with the basics...

    here's the proc from a thread on the subject; it's idea for setting up your mysql linked server:

    http://www.sqlservercentral.com/Forums

    --http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

    CREATE PROC uspCreateLinkToMySQLDB @linkedservername varchar(50), @mysqlip varchar(50),...

    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!

    February 6, 2012 at 2:52 pm

    #1443463

  • RE: Advice on BINARY_CHECKSUM or Alternatives

    can you create a view on top of the staging table tat would type the data into the same matching types as the production data?

    then you could binary checksum 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!

    February 6, 2012 at 2:35 pm

    #1443447

  • RE: create 2 databases with same name on the server

    Sean Lange (2/6/2012)

    Databases don't have IP addresses. The IP address belongs to the server. Like said before you would need to have named instances running to have the same 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!

    February 6, 2012 at 11:48 am

    #1443362

  • RE: Disabling SSMS connection for few uses

    Damian-167372 (2/6/2012)

    yes I am working with the management team to do this ...

    thanks a lot for your information ..

    I also hard coded the script with app name something like...

    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!

    February 6, 2012 at 11:03 am

    #1443339

  • RE: Disabling SSMS connection for few uses

    Gazareth (2/6/2012)

    Ha, so basically, what Gail said... 😀

    awfully easy to change if you know what to look for:

    :

    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!

    February 6, 2012 at 9:19 am

    #1443248

  • RE: problem using left join - not showing all possible results

    because you are using string compare (the LIKE)

    whitespace is important...if you look at your data, there is a preceeding space before every number...so your join criteria is limited to matching...

    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!

    February 6, 2012 at 7:58 am

    #1443157

  • RE: Old Dog, New Tricks

    naw, it's pretty easy to review all the procs, even when they are encrypted...it's really just "obfuscation", so it just requires a couple of extra steps to see the code...

    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!

    February 6, 2012 at 6:40 am

    #1443077

  • RE: Stand Alone Database Server

    You didn't take the clients business model into consideration;

    the SBS solution is ideal for small businesses; minimal IT staff, and all that.

    you should recommend that they get the SBS Premium...

    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!

    February 4, 2012 at 6:08 am

    #1442740

  • RE: beginner requesting help with trigger that updates a table when an insert occurs in another

    learning how triggers work is absolutely valuable, so continue what you are doing.

    you really need to grasp the use of the INSERTED and DELETED tables , and how 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!

    February 4, 2012 at 4:41 am

    #1442737

  • RE: Script for finding parent procedure

    there's a quick fix for that, though; you can simply ALTER all your procedures. which will fix the sysdepends; if everything was rebuilt correctly, your dependencies are up to date.

    note...

    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!

    February 3, 2012 at 2:41 pm

    #1442660

  • RE: Old Dog, New Tricks

    jcb (2/3/2012)

    You are right, no verbatim literal strings to VB.net...sorry

    But you can use:

    Dim s as String _

    = "string1" _

    & "string2" _

    & "string3"

    😛

    if you are using 3.5 Framework or above(or maybe...

    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!

    February 3, 2012 at 12:46 pm

    #1442607

  • RE: Calendar table, Equinox/Solstice & Astronomy calculations

    Steve_o (2/3/2012)

    Thank you for the link, Jason.

    This is partly what I was looking for. I had wanted to provide even more in-depth info if possible.

    Jason thanks for the salute...

    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!

    February 3, 2012 at 11:56 am

    #1442579

  • RE: Compare SP between Databases EXCLUDING NULL

    i do something similar for comparing schemas and proc/view/function definitions, but i do it in an application, instead of as a procedure;

    my logic: i want to compare functional definitions; i...

    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!

    February 3, 2012 at 11:30 am

    #1442568

  • RE: [LOG] Block procedure or delete to record at log file?

    nope, EVERYTHING is logged, whether simple mode or FULL; it's just simple mode commits the changes right away and issues a check point.

    you could consider having the procedure do 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!

    February 3, 2012 at 9:48 am

    #1442510

Viewing 15 posts - 5,971 through 5,985 (of 13,460 total)