Forum Replies Created

Viewing 15 posts - 6,016 through 6,030 (of 13,460 total)

  • RE: Export to TIFF

    i thought TIFF was an image format, so it's not really pages...

    if you had a 10 pages in that single image, do you want an image that is 8.5 inches...

    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, 2012 at 1:33 pm

    #1438426

  • RE: SQL Developer licensing

    here's my two cents.

    a linked server is just a connection to a licensed server.

    no different from whether i connect via an application i create, or from a developer...

    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, 2012 at 9:31 am

    #1438282

  • RE: DBCC Check database consistency errors:

    Gail will weigh in I'm sure, as she's had a lot more experience on this, but I'm very sure that unrepairable error. = restore from backup, as it cannot 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 25, 2012 at 7:09 am

    #1438223

  • RE: Migrating all MS SQL Server Databases

    oops wrong post sorry.

    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, 2012 at 6:02 am

    #1438184

  • Reply To: Create User, Role, Grant Permission

    Laura_SqlNovice (1/24/2012)

    So Lowell I should make the user db_ddladmin and then create DDL triggers to stop users from altering, dropping objects?

    well Laura i threw some time at this, as it...

    • This reply was modified 7 years, 3 months ago by Lowell.
    • This reply was modified 6 years, 9 months ago by Lowell. Reason: reformatted due to new web design for code tags

    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, 2012 at 8:06 pm

    #1438067

  • RE: Create User, Role, Grant Permission

    Laura this is a tough one;

    SQL doesn't have granularity you are looking for;

    it's pretty much grant ALTER on the schema, and that applies to all the DDL for all objects,...

    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, 2012 at 3:21 pm

    #1438001

  • RE: DMVs go how far back?

    my examples of that would depeend on how much memory you had for plans to stay cached in memory, i think;

    SELECT

    fn.*,

    st.*

    FROM ...

    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, 2012 at 1:58 pm

    #1437953

  • RE: DMVs go how far back?

    it depends on WHICH DMV also;

    sys.dm_exec_connections are only valid while the spid is connected, i think;

    sys.dm_db_index_usage_stats is good until a stop start,

    but i think sys.dm_exec_query_plan would get cleared...

    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, 2012 at 1:49 pm

    #1437944

  • RE: Replace (--)

    i'm guess it's more complicated than the original post's simple REPLACE function

    ...for example if he's trying to replace stored procedure text, but there's code that does something like ISNULL(Category,'--');

    he cannot...

    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, 2012 at 1:45 pm

    #1437942

  • RE: How to handle sql server stored procedure output parameter in .bat file

    well, SQL server has no problem returning negative numbers...maybe it's a command line limitation?

    CREATE PROCEDURE checkstate @param int

    AS

    return @param;

    GO

    DECLARE @return_status int;

    EXEC @return_status = checkstate -1;

    SELECT 'Return Status' = @return_status;

    GO

    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, 2012 at 10:30 am

    #1437809

  • RE: List all user databases the perform operation on each one

    all the databases can be selected from master.sys.databases;

    SELECT * FROM master.sys.databases

    WHERE database_id > 4 --skip master/tempdb/model/msdb

    i would probably generate my list of commands from that same sql, and execute 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!

    January 24, 2012 at 6:22 am

    #1437630

  • RE: Best way to return a 1 or 0 for an if exists query

    i think you can do it inline with a sub select, like this without using an If structure:

    CREATE Procedure [dbo].[sp_GGA_Testing]

    @status int,

    @ID int

    As

    SELECT ISNULL(ExistsVal,0)

    FROM

    (select 1 AS ExistsVal

    from tblONE

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

    January 23, 2012 at 12:03 pm

    #1437296

  • RE: unable to bring database in single user mode

    if you use the optional WITH ROLLBACK IMMEDIATE, it will disconnect everyone from the database.

    ALTER DATABASE Logging_demoSP2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    --do some exclusive stuff, like RESTORE

    --if the database as...

    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 23, 2012 at 11:11 am

    #1437258

  • RE: How to get text output from a scheduled sp on 2005 to a file

    Random Visitor (1/23/2012)

    We don't have SSIS installed so is there any way a Job can be run to direct the output from an executed sp to a text file 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!

    January 23, 2012 at 9:25 am

    #1437196

  • RE: Single DB vs 2 DBs

    how you need to report or aggregate the information may play a factor; also whether they ever reference each others data.

    the data is really independent of each other, right? there'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!

    January 23, 2012 at 8:18 am

    #1437129

Viewing 15 posts - 6,016 through 6,030 (of 13,460 total)