Forum Replies Created

Viewing 15 posts - 11,386 through 11,400 (of 13,460 total)

  • RE: serial no

    that error could occur if your database compatibility level is at 80 instead of 90;

    the compatibility level determines which syntax version is applied to statements hitting the database, and rownnumber()...

    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 21, 2009 at 6:27 am

    #963957

  • RE: serial no

    My questions are the same:

    what is a serial number to you? is it a random number? can it be '0000' plust the customer number?(0001,0002, etc). Why did your example...

    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 20, 2009 at 11:51 am

    #963717

  • RE: Does a CLR Assembly autmaticaly (.dll) get backed up durring db backup

    yes, the CLR is actually saved in the database, along with it's source code...so if you were to backup a database, change the CLR and redeploy it, then restore 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 20, 2009 at 10:22 am

    #963655

  • RE: REBUILD THE INDEXES BY FILE GROUP

    I like Florians script...added it to my snippets.

    my only changes are I added the filegroup name and removed the WHERE statement...i want a script that generates all the DBCC 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!

    March 20, 2009 at 10:14 am

    #963645

  • RE: REBUILD THE INDEXES BY FILE GROUP

    the same script that Florian gave you, simply change the file group name and change the line that says DBCC REINDEX to this:

    'UPDATE STATISTICS ' + SCHEMA_NAME(st.schema_id) +...

    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 20, 2009 at 10:02 am

    #963635

  • RE: how to break phone and exension data

    ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume starting with...

    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 20, 2009 at 9:05 am

    #963592

  • RE: how to break phone and exension data

    here's how i would do it.

    I'm assuming that you are using US format for area codes..(800) xxx-yyyy ext.zzzz

    some of your area code exampels started with 1, i.e. 109, which does...

    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 20, 2009 at 8:58 am

    #963582

  • RE: date format yyyyMMddhhmmss

    here's how i do it:

    FormattedDate SQL

    20090320-09:33:49:700 SELECT CONVERT(VARCHAR,@date,112) + '-' + CONVERT(VARCHAR,@date,114)

    20090320-093349700 ...

    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 20, 2009 at 7:37 am

    #963513

  • RE: Forum Software question

    Brandi one of the best forum platforms out there for phpBB/MySQL stuff out there is phpBB http://www.phpbb.com/%5B/url%5D

    free, open source,

    full featured easy to use, huge deployment so you can 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!

    March 19, 2009 at 12:12 pm

    #962995

  • RE: How to Create and Start SQL Server Trace Automatically

    yeah, for event 12 SQL:BatchCompleted, even when everything is enabled, there is a lot of null columns, i can see that you want to capture just certain data depending 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 19, 2009 at 11:14 am

    #962928

  • RE: Last Store procedures used or executed

    you need to add a different trace; a great example from Perry Wittle is found here:

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

    AFTER that is in place, you will be able to determine who ran a SQL...

    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 19, 2009 at 11:11 am

    #962926

  • RE: How to Create and Start SQL Server Trace Automatically

    Perry your code example was very helpful for me today, as I wanted to create a DML trace to be a companion to the existing DDL default trace.

    so I played...

    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 19, 2009 at 10:28 am

    #962883

  • RE: Counting Specific Tables In a Database

    here's my comparison snippet for SQL 2000:

    create table #rowcount (tablename varchar(128), rowcnt int)

    exec sp_MSforeachtable

    'insert into #rowcount select ''?'', count(*) from ?'

    --tablename is [dbo].[TBLNAME] instead of plain...

    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 19, 2009 at 8:56 am

    #962772

  • RE: Counting Specific Tables In a Database

    Maxim Picard (3/19/2009)

    Hi again

    I saw Lowell's post after replying...

    How reliable is the count in sys.partitions because a solution based on that will definitly beat a cursor on speed!

    Maxim's right, unless...

    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 19, 2009 at 8:49 am

    #962764

  • RE: Counting Specific Tables In a Database

    Maxim's code will work, and would obviously only run for the tables that exist in your counting table...

    but if you compare it to the set based solution, it'll be 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!

    March 19, 2009 at 8:45 am

    #962757

Viewing 15 posts - 11,386 through 11,400 (of 13,460 total)