Forum Replies Created

Viewing 15 posts - 5,851 through 5,865 (of 13,460 total)

  • RE: change initial size of tempdb

    size will not change until you stop and restart the server.

    at that time tempdb , since it will be recreated, will change to 10G instead of it's current size.

    I don't...

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

    #1454356

  • RE: AUTO_CLOSE reverts to ON in db created by attaching .mdf

    sudnya_s (3/2/2012)

    I am seeing the same behavior. Auto close resets to true after a detach and attach.

    yeah, as we explained above, if you are running an EXPRESS version, NO MATTER...

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

    #1454277

  • RE: Scripting out DBMail Setup

    also, look at my forum post here:

    Reverse Engineer DatabaseMail Settings

    where i answered my own question with a TSQL script;

    note the core issue is the CREDENTIAL for the SMTP user ;...

    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 2, 2012 at 7:16 am

    #1454151

  • RE: Extracting a value stored in Byte 1 of a 32-bit (int) status field

    i think this is going to get what you are after; i'm returning true/false based on the value of the first 4 bytes; with that i think you can see...

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

    #1454115

  • RE: create a constraint over 30 columns to have a Unique combination

    how about a calculated , persisted column using either a hash or binary checksum, and a unique constraint on that? that gets rid of triggers and is self maintaining.

    ALTER TABLE...

    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 2, 2012 at 5:42 am

    #1454106

  • RE: Server side Trace

    --#################################################################################################

    --Begin Event definitions

    --#################################################################################################

    exec sp_trace_setevent @traceidout,114,1,@on --Audit Schema Object Access Event,TextData

    exec sp_trace_setevent @traceidout,114,3,@on --Audit Schema Object Access Event,DatabaseID

    exec sp_trace_setevent @traceidout,114,8,@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 1, 2012 at 4:02 pm

    #1453942

  • RE: deploy stored procedure from dev/test to production with different linked server names

    another possibility could be that the linked servers on DEV and LIVE have the same names, but different definitions.

    it's not obvious, but you can create a linked server with any...

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

    #1453797

  • RE: Stored procedure help

    does the select statement i'm providing produce the list of items that would need to be updated;

    you didn't mention the actual table naem to be updated...you'll need to change that.

    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!

    March 1, 2012 at 11:04 am

    #1453789

  • RE: Function to return all separators from text column

    here's just one way to do it;

    this strips out every char that is a-z,A-Z and 0-9, leaving, i assume, what would be the word separators, like space, dash, comma,...

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

    #1453710

  • RE: Windows Auth with no SysAdmin Users! HELP

    Roger Lindsay (3/1/2012)

    There is no need to restart is single user mode, you run a scheduled task as nt authority\system.

    http://sev17.com/2011/10/gaining-sql-server-sysadmin-access/%5B/url%5D

    I had not seen that technique, Roger.

    Thanks for the link!

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

    #1453587

  • RE: Creating a Computed column as a percent of two colums

    your issue is integer division;

    in sql server, if you divide an integer by an integer, you get an integer...bot a decimal that you might get in a programming language.

    so 99/100...

    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!

    February 29, 2012 at 8:05 pm

    #1453439

  • RE: deploy stored procedure from dev/test to production with different linked server names

    you can test whether the synonym exists in the proc and bailout if necessary.

    Create Procedure DoStuff

    AS

    BEGIN

    IF (SELECT OBJECT_ID('REMOTETABLE','SN')) IS NULL

    RAISERROR('Required Synonym [REMOTETABLE] does not exist!',16,1)

    --do stuff

    END --PROC

    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!

    February 29, 2012 at 3:12 pm

    #1453393

  • RE: deploy stored procedure from dev/test to production with different linked server names

    how many objects are being accessed via the linked server?

    you might consider creating synonyms for the objects. if there is a zillion of them, or dynamic SQL is being used,t...

    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!

    February 29, 2012 at 2:51 pm

    #1453385

  • RE: Server side Trace

    sunny.tjk (2/29/2012)

    Thanks Lowell.

    Please correct me if I'm wrong--Isn't 32767 the databaseid of resource database?

    I'm sorry, i'm completely uninformed on that and i have no idea .

    in my 2008 dev version,...

    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!

    February 29, 2012 at 11:12 am

    #1453317

  • RE: Server side Trace

    i added your filter to a trace and used my tool to script it back out;

    --#################################################################################################

    --begin filter definitions

    --#################################################################################################

    -- WHERE 1 = 1

    exec sp_trace_setfilter @traceidout,3,0,1,32767 -- 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!

    February 29, 2012 at 9:45 am

    #1453256

Viewing 15 posts - 5,851 through 5,865 (of 13,460 total)