Forum Replies Created

Viewing 15 posts - 12,646 through 12,660 (of 13,460 total)

  • RE: Query for registry entry date and time.

    you are right...you can read or write a registry key, but there is no log or anything to tell you when a registry key was created/edited.

    if there is a key...

    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!

    March 8, 2007 at 7:44 am

    #693813

  • RE: scripting primary and foreign keys

    i should have mentioned, and you probably found it...the second sql can produce a ton of results, so i limited it to top 100...you'd pull that out to get all...

    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!

    March 8, 2007 at 6:56 am

    #693794

  • RE: scripting primary and foreign keys

    if you have access to the original db on 2005, you can use the scripts below ; here you go:

    first script generates both drop and add foreign key statments;

    second script...

    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!

    March 8, 2007 at 5:09 am

    #693770

  • RE: Sql 2000 production server SP4 not installed

    it's been a couple of months since i last installed an SP4 on a SQL server, but it went less than 15 minutes as i remember; if your server is...

    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!

    March 7, 2007 at 1:47 pm

    #693656

  • RE: Placeholders in EXEC statements

    because you are doning dynamic SQL, you'll want to put the SQL command in a string with a placeholder, and then replace the placeholder prior to the real exec statement....

    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!

    March 7, 2007 at 11:49 am

    #693635

  • RE: Sql 2000 production server SP4 not installed

    time changes are at the operating system level..there is a registry patch for the operating system to change the daylight savings time on the new date available from 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!

    March 7, 2007 at 11:44 am

    #693632

  • RE: 80040e07 Error on testing server

    do not cross post...the Active topics function allows everyone to see new posts, regardless of forum. there is no need to ask the same question in multiple places.

    answered here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=349780

    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!

    March 7, 2007 at 11:41 am

    #693630

  • RE: removing the identity property of a column

    the correct answer is to not remove the identity at all...NEVER update sys tables directly...

     

    the identity column sis there for conveneince, and you can still insert by setting an additional...

    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!

    March 7, 2007 at 11:33 am

    #693629

  • RE: Run-time error 80040e07

    that error is usually when you try and stick 10 characters into a field that is smaller than 10 for example...check the TEST server's DDL for the table...i would bet...

    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!

    March 7, 2007 at 11:24 am

    #693624

  • RE: Reading from a text file

    you might want to consider writing a program to do the work(open file, manipulate, save file) instead of in TSQL; most languages are more robust in their ability to edit files...

    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!

    March 6, 2007 at 10:17 pm

    #693460

  • RE: Create a list of DB names/multiple SQL servers from a single server

    i have this procedure that i use; sorry i don't know the source of where i got it: this lists all servers on the network, you'd then need to query...

    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!

    March 6, 2007 at 10:33 am

    #693378

  • RE: Why Query Analyzer not able to detect missing column in table for Sql2k

    thanks Jeff I should have thought of that...he never said "procedure" so i assumed he was talking about ad hoc queries.

     

    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!

    March 6, 2007 at 6:24 am

    #693287

  • RE: Why Query Analyzer not able to detect missing column in table for Sql2k

    yes... if you select @@version, you would most likely see this:

    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

     May  3 2005 23:18:38

     Copyright (c) 1988-2003 Microsoft Corporation

     Enterprise Edition on...

    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!

    March 5, 2007 at 8:34 pm

    #693234

  • RE: programatically detemine VIEW source

    I might be mis-understanding the question, but...

    if you are re-using the same view name, and recreating it with different SELECT statements, then you should be able to use the command...

    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!

    March 5, 2007 at 12:05 pm

    #693189

  • RE: Strongly Typed Datasets (.net 2)?

    similar issues here that Steve reported;

    we started using strongly typed data sets, and found issues when the underlying structure changed...if we added a column to a table, for example, 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!

    March 5, 2007 at 11:58 am

    #693186

Viewing 15 posts - 12,646 through 12,660 (of 13,460 total)