Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 13,460 total)

  • RE: Not able to connect to ssms

    sounds like security: remember in SQL 2008, or whenever installed on win7/server2003 and above, local admins on a box are no longer admins in SQL.

    connect as sa, add your...

    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!

    August 17, 2011 at 12:17 pm

    #1369785

  • RE: Trace audit LoginName shows app account not logged in user

    if the application is logging in with a SQL login, you cannot get the NT user information.

    Going forward, you'd have to change the application to start passing thru the NT...

    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!

    August 17, 2011 at 11:09 am

    #1369750

  • RE: Is It safe to Run Trace on production server?

    a server side trace typically has no performance impact, unless you create a trace that is logging everything; every column and every event would probably be a bad idea.

    I'm in...

    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!

    August 17, 2011 at 7:43 am

    #1369594

  • RE: DB Mail

    msdb has some tables which contain the errors and their details.

    i create a view to make them eaiser to access, i think this might help you.

    i get errors like this:

    ...

    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!

    August 17, 2011 at 5:50 am

    #1369519

  • RE: Sending message to SQL Server 2008

    jamesnt (8/16/2011)

    LOL!

    We have an issue where after data entry, certain fields need to be verified. I was hoping to create a SSIS package that end users could...

    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!

    August 16, 2011 at 2:01 pm

    #1369314

  • RE: truncate table and forign key constraints

    a foreign key always prevents truncation.

    to do the same thing it requires two separate steps.

    instead you have to delete, and then maybe reseed the identity

    DELETE FROM MyTable

    DBCC CHECKIDENT( [MyTable],RESEED,1) --reset...

    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!

    August 16, 2011 at 1:47 pm

    #1369301

  • RE: sys.dm_db_index_physical_stats DMV

    no...SELECT * FROM sys.objects selected from the current database.

    sp_msForEachDB 'select

    ''?'' as DbName,

    name

    ,object_id from ?.sys.objects

    where object_id = 2073058421 '

    would show you all the objects that , buy...

    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!

    August 16, 2011 at 1:05 pm

    #1369276

  • RE: sys.dm_db_index_physical_stats DMV

    Vicki I'm pretty sure the issue is that the same object_id exists in multiple databases....

    that view returns multiple database results, not just results from a single database.

    change that query to...

    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!

    August 16, 2011 at 12:54 pm

    #1369270

  • RE: Auto-update Record Based on Today's Date and Future Date?

    i think what you want is a schedule job that runs every day.

    that job updates rows meeting your criteria for being delinquent.

    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!

    August 16, 2011 at 12:03 pm

    #1369234

  • RE: Check Constraint and Case Statement

    when i read this requirement:

    If InformationRestricted is True,

    InformationNotRestricted cannot be true

    and InformationRestrictedFromLevel1,

    InformationRestrictedFromLevel2,

    InformationRestrictedFromLevel3,

    InformationRestrictedFromLevel4,

    InformationRestrictedFromLevel5 cannot be true

    i see that as saying a suite of constraints like...

    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!

    August 16, 2011 at 11:35 am

    #1369221

  • RE: Returning row count as output in CTE

    ChrisM@Work (8/16/2011)

    Was it the key seek method, explained elegantly by Paul White here[/url]?

    that post from Paul exactly encapsulates that portion of his presentation Chris, yes.

    » Dmitri Korotkevitch's web site, now...

    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!

    August 16, 2011 at 9:13 am

    #1369138

  • RE: how to add not null column in sql server 2005

    Danzz (8/16/2011)

    I am trying to add NOT NULL column to existing table.

    when I try to add it throws an error.

    Msg 4901, Level 16, State 1, Line 1

    ALTER TABLE only...

    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!

    August 16, 2011 at 8:40 am

    #1369118

  • RE: SQL Server 2000 SP4

    I googled and didn't find anything definitive that said you had to upgrade to SP4 prior to upgrading to 2008...where did you see that?

    my recommendation would be only if 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!

    August 16, 2011 at 6:02 am

    #1369023

  • RE: Alternative for KILL

    Gail, would disconnecting every connection, as an attempt to clear whatever is blocking that rollback, be helpful at all?

    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!

    August 16, 2011 at 5:57 am

    #1369020

  • RE: sql smtp

    you'd need to call a either a third party dll like we used to have to in SQL2000 (via cmdshell and sp_oaCreate)

    I used to use a dll from AspEmail 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!

    August 16, 2011 at 5:48 am

    #1369016

Viewing 15 posts - 6,931 through 6,945 (of 13,460 total)