Forum Replies Created

Viewing 15 posts - 4,081 through 4,095 (of 13,460 total)

  • RE: changing a sql 2005 developer license to production

    looks like he's correct to me;

    according to this page,neither standard nor enterprise will upgrade/replace an existing developer instance:

    take a look here:

    http://msdn.microsoft.com/en-us/library/ms143393.aspx

    so to get everything correct, you need to do 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!

    January 28, 2013 at 10:51 am

    #1581730

  • RE: SQL design discussion - help required

    besides identifying the columns in the table, you need another attribute to identify what makes a collection of columns unique, especially if it's not the PK of the table and...

    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!

    January 28, 2013 at 9:51 am

    #1581701

  • RE: Table with one row: Bad idea or not?

    in our case, we have a config file that has the connection string information, and a single row table that contains a lot of settings relevant to the application that...

    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!

    January 28, 2013 at 9:46 am

    #1581697

  • RE: Pulling errors from a linked server

    Toby I'm not sure if this is what you are looking for;

    this is just a try-catch structure that is parsing out the elements of the error; i'm not sure what...

    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!

    January 28, 2013 at 9:24 am

    #1581682

  • RE: BCP native format data issue on import

    run bcp /? from the command prompt for all the possible flags;

    i think the one you want is the -E flag:

    -E keep identity values

    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!

    January 28, 2013 at 9:05 am

    #1581674

  • RE: create synonym to schema

    nope a synonym must point to an object ( an object that would exist in a databases sys.objects view), and not part of the name of an object.

    so by definitions,...

    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!

    January 28, 2013 at 8:23 am

    #1581649

  • RE: address management software

    depending on how many addresses you need to validate,(and you want to do it yourself) this link below could be an option;

    i'ved used this to clean up and validate...

    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!

    January 28, 2013 at 6:08 am

    #1581581

  • RE: facing serious performance issues, please see the scenario below need urgent help - Please chk the code below

    chris@home gave you teh best advice so far: if you can rewrite teh query, redo it so that it is 5 unions, using the agregate example he already put 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!

    January 27, 2013 at 12:19 pm

    #1581383

  • RE: Generate sciprt for large table with command

    sounds like you are getting an error because you have a database greater than ten gig on a SQL express installation;

    my recommendation would be to spend $45 dollars and buy...

    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!

    January 26, 2013 at 8:26 pm

    #1581350

  • RE: Best approach to group databases within an instance.

    i hope you mean multiple databases on a single SQL Server installation, and not multiple SQL Server Installations, one for each "application"

    If there are going to be any reports or...

    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!

    January 25, 2013 at 1:32 pm

    #1581212

  • RE: facing serious performance issues, please see the scenario below need urgent help - Please chk the code below

    statsics look real bad in two of the queries (200K+ rows estimated, actual = 0

    and pretty bad for the rest;

    running this, with no other changes, will at least help 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!

    January 25, 2013 at 12:15 pm

    #1581186

  • RE: facing serious performance issues, please see the scenario below need urgent help - Please chk the code below

    also, my rule of thumb is that any @TableVariable with more than a few hundred rows should be a temp table instead, to allow the system to automatically do things...

    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!

    January 25, 2013 at 11:24 am

    #1581163

  • RE: Query to find username/login name of a particular query executed at particular time.

    if you don't have a customized trace, CDC, SQL Audit, or some other set of tracking in place prior to the query being executed, there's no way to find...

    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!

    January 25, 2013 at 8:07 am

    #1581059

  • RE: Finding database file growth for last one year

    it's not stored anywhere , i think; I believe you'll have to find a year old backup and compare that to todays backup.

    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!

    January 24, 2013 at 3:09 pm

    #1580728

  • RE: dynamically creating data base and tables by stored procedure?

    since the proc would create the same tables all the time, it seems to me a stored proc which simply restores a backup as a new database name might 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!

    January 24, 2013 at 2:55 pm

    #1580723

Viewing 15 posts - 4,081 through 4,095 (of 13,460 total)