Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 13,460 total)

  • RE: How could i find the client?

    session is single_user mode, or the database?

    if it's the database,

    you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who'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!

    May 2, 2013 at 9:47 am

    #1611936

  • RE: CURSOR - running very slow

    npyata (5/2/2013)

    Here is the code. This is my first step in the process and after this seq_no update I need to update some other columns based on this seq_no.

    USE...

    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!

    May 2, 2013 at 9:35 am

    #1611931

  • RE: Error while taking backup for a user not having sysadmin permission

    there are lots of other functionalities that SSMS assumes you must have sysadmin rights in order to perform actions;

    most of the nodes in the Object explorer assume it, ...

    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!

    May 2, 2013 at 8:34 am

    #1611907

  • RE: varchar(N), N can be 1 through 8000 or MAX(2GB). Why not 1 - 2GB?

    thank you Gail!

    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!

    May 2, 2013 at 7:09 am

    #1611878

  • RE: Out of the two given queries, which will perform faster!!!

    they are the same query, but with a some expressions to calculate the field values.

    test it yourself by looking at the actual execution plans when you run them.

    they will both...

    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!

    May 2, 2013 at 7:07 am

    #1611876

  • RE: varchar(N), N can be 1 through 8000 or MAX(2GB). Why not 1 - 2GB?

    Tobar (5/2/2013)

    Anyone have an idea why the varchar data type is limited to be 1 through 8000 or MAX(2GB) but none of the numbers between 8001 and 2GB?

    Just one...

    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!

    May 2, 2013 at 6:31 am

    #1611861

  • RE: Question about MAX_QUEUE_READERS in Service Broker.

    duplicate post.

    There's no need to post the same question in multiple forums.

    The Recent Topics function most people use shows us your post immediately.

    crossposting will wastes people's time and fragments replies....

    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!

    May 1, 2013 at 2:54 pm

    #1611727

  • RE: Making Query SQL 2000 compatable

    wow it's been a long time since i had to do this in SQL2000;

    SQL 2000 doesn't support row_number() functions either.

    if you can go without row_number, it just becomes a sub...

    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!

    May 1, 2013 at 2:50 pm

    #1611724

  • RE: Creating a least-privelege SQL Server 2012 user/login for running ASP.net parameterised queries

    a slight modification if you are using windows authentication:

    -- we need a login for the Web To Use:

    CREATE LOGIN [DEV223\ASPNET] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    --pick the right db!

    USE [WHATEVER]

    --now we...

    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!

    May 1, 2013 at 10:16 am

    #1611642

  • RE: Creating a least-privelege SQL Server 2012 user/login for running ASP.net parameterised queries

    here's an example i adapted from another one I've used int eh forums here:

    -- we need a login for the Web To Use:

    create login WebUser with password = 'NotTheRealPassword'

    --pick 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!

    May 1, 2013 at 10:08 am

    #1611640

  • RE: SQL inner join: ORA-00904: "Bonus.site_name": invalid identifier?

    In Oracle, Each Object can have double quotes. that means the table can have quotes, and it's column names can have quotes...but you can't wrap them all in-one..they each get...

    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!

    May 1, 2013 at 7:39 am

    #1611552

  • RE: Droping out of a cusor

    You are looking for the BREAK keyword.

    a simple example to break out of what would otherwise be an endless loop:

    --RAISERROR immediate message

    --print error immediately in batch

    DECLARE

    @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!

    May 1, 2013 at 6:33 am

    #1611530

  • RE: Generate two columns from single column with alternating data

    you can join the table against itself, and use the modulus operator to limit it to the "odd" rows for the first value, leaving the second value as the date-ish...

    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!

    April 29, 2013 at 1:56 pm

    #1610995

  • RE: How To Avoid The Duplicate Records....

    excellent! glad we could guide you in the right direction; I for one am very glad you were able to solve this with just a gentle nudge!

    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!

    April 29, 2013 at 1:01 pm

    #1610969

  • RE: SQL Server outof space question.

    ouch; remote-second hand assistance is tough,

    I feel for you and what headaches are involved in getting your information once-removed from the client.

    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!

    April 29, 2013 at 12:59 pm

    #1610968

Viewing 15 posts - 3,556 through 3,570 (of 13,460 total)