Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 13,460 total)

  • RE: Tempdb slowly after migrating on SQL Server 2008 R2

    Phillippe can we review some basic setups first?

    What is the default size of tempdb? at startup, by default, it's a piddling 8 meg, and would grow by 1 meg at...

    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!

    September 26, 2011 at 7:00 am

    #1386443

  • RE: using sp_send_dbmail

    in the msdb database, you'll need to add the user, adn then make him a member of the [DatabaseMailUserRole] role.

    USE [msdb]

    GO

    CREATE USER [user1] for login [user1]

    EXEC sp_addrolemember 'DatabaseMailUserRole','user1'

    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!

    September 25, 2011 at 8:31 pm

    #1386267

  • RE: Scalar Function returns only one char

    RETURNS nvarchar

    unless you explicitly state a size, the default is 1;

    it's only when you are using cast or convert that the unstated size is 30

    it's pretty common to assume ...

    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!

    September 25, 2011 at 12:39 pm

    #1386233

  • RE: Using CONTEXT_INFO() in fields default value

    i think the issue is contextinfo is varbinary(128); you have to convert to nvarchar, and then to biginto to get the value you want.

    exec

    sp_help 'master.dbo.sysprocesses'

    DECLARE @var VARBINARY(128)

    SET @var...

    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!

    September 25, 2011 at 6:14 am

    #1386201

  • RE: Cloaking databases from different users

    Seth when i change the database owner, i seem to see exactly what id'd expect...two more databases

    using my same code from above:

    DENY VIEW ANY DATABASE TO DBVIEWERTESTING

    USE SandBox

    GO

    exec sp_changedbowner DbViewerTesting

    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!

    September 23, 2011 at 1:36 pm

    #1386022

  • RE: Is this abug?

    don't you have to stop and start the service to change the config values into run values?

    i suspect the 3=changes pending as an undocumented status.

    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!

    September 23, 2011 at 11:39 am

    #1385950

  • RE: Cloaking databases from different users

    the command you are looking for is this snippet to hide databases the end user doesn't have access to:

    DENY VIEW ANY DATABASE TO [SomeUserOrRole]

    here's some testable code to prove...

    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!

    September 23, 2011 at 11:31 am

    #1385948

  • RE: get due amount of of all invoices of given supplier

    fully consumable, copy and paste example:

    CREATE TABLE [dbo].[tbl_Purchase] (

    [Purchase_id] bigint ...

    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!

    September 23, 2011 at 7:50 am

    #1385742

  • RE: get due amount of of all invoices of given supplier

    dilip.aim11 (9/23/2011)

    i sent sample data.... Plse Check this..

    Thnks

    that's not sample data....

    what we need is "consumable" data...copy and paste into SSMS, run it, so we have a setup that mimicks 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!

    September 23, 2011 at 7:43 am

    #1385732

  • RE: get due amount of of all invoices of given supplier

    Since this is your first post, let me try and give you an example of what we really need to help you, just like Gianluca suggested

    i ran this thru...

    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!

    September 23, 2011 at 7:36 am

    #1385721

  • RE: finding Structure of the table

    prakash 67108 (9/23/2011)

    Hi,

    Is it possible to find last modified date of the table and previous structure of the table after it is altered...?

    Thanks

    you can get the last modified date if...

    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!

    September 23, 2011 at 6:20 am

    #1385652

  • RE: Best Practices for Scripting in SQL Server

    we use compound IF EXISTS commands to make sure that a table we KNOW exists....well exists...

    (if it's our version of a database)...

    it eliminates issues where the IF NOT EXISTS...CREATE 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!

    September 22, 2011 at 2:29 pm

    #1385448

  • RE: How to trigger emails based on insert SQL 2003 or 2005

    techzone12 (9/22/2011)

    Thanks for the code. I am looking at it. One of the requirments is to have one email for each event.

    There probably needs to be some sort of...

    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!

    September 22, 2011 at 2:23 pm

    #1385443

  • RE: Help required to extra image from varbinary column and create image on file system

    Elliott Whitlow (9/22/2011)

    If you chose to use the code from codeplex and have any trouble let me know, I am the author.

    CEWII

    Elliot that is a really nice project, and was...

    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!

    September 22, 2011 at 1:54 pm

    #1385418

  • RE: 2 distinct instances of SQL Server 2005 - One jerks the other

    well, "instance" is a keyword for SQL server, do you mean two installations of SQl server on the same physical machine, or do you mean two separate servers, both 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!

    September 22, 2011 at 1:37 pm

    #1385404

Viewing 15 posts - 6,691 through 6,705 (of 13,460 total)