Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 13,460 total)

  • RE: Why can't user get into DB?

    do you have a logon trigger that is sending an email message or logging to a table in MSDB or something?

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

    #1456135

  • RE: Trigger document

    the UPDATE() function is really misleading;

    With "UPDATE(xyzID) " for example,

    a lot of people interpret that to mean "If Column (xyzID) changed".

    actually SQL interprets it as "If the column xyzID 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!

    March 7, 2012 at 10:30 am

    #1456133

  • RE: tracking data changes

    imranx101 (3/7/2012)

    Hi,

    How can I tell which user inserted or updated data in a table? Is that possible i can know?

    Thanks

    Not without having something in place first; SQL doesn't keep track...

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

    #1456128

  • RE: How to acknowledge DB has been restore?

    It depends on what you want to do;

    it sounds like creating a event notification for AUDIT_BACKUP_RESTORE_EVENT might work, depending on what you are doing.

    I've played with that for automatically running...

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

    #1455563

  • RE: Connect to SQL server 2008 from Excel/Access - with user specified userID/Pwd

    SQL server does not have windows passwords. what happens is SQL server checks the token Windows passes from Integerated security to see if you have access. SLq assumes that...

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

    #1455491

  • RE: central attachment/file table

    HowardW (3/6/2012)

    That's exactly what I suggested in the first post, other that renaming the table AllAttachments...:-)

    doh! i see that 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!

    March 6, 2012 at 8:30 am

    #1455363

  • RE: central attachment/file table

    something like this?

    CREATE TABLE [dbo].[ATTACHMENTS] (

    [ATTACHMENTID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [NAME] ...

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

    #1455362

  • RE: central attachment/file table

    Anything wrong with having an "AllAttachments" table, and then a multiple linking tables that join the desired tables keys together?

    So for example, if i decided to add an attachments ...

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

    #1455349

  • RE: Query Identify Natural Primary Key Columns

    Along Eugene's lines of code review, I've found that a very high percentage of table designs have the first column or the first few columns actually define a primary key...

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

    #1455271

  • RE: Problem to write Special Function

    there's no easy button or magic function that you can use to fix your issue without any work on your part, sorry.

    As Jeff already identified, you'll have to fix 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!

    March 6, 2012 at 5:27 am

    #1455222

  • RE: Select IMAGE datatype

    can you add a CLR?

    Elliot Whitlow, a contributor here, has a very nice CLR project for file manipulation;

    http://nclsqlclrfile.codeplex.com/

    the code example like this works great, you cna see how you 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!

    March 5, 2012 at 3:23 pm

    #1455051

  • RE: IMPORT / EXPORT DATABASE TABLES

    twdavis-893252 (3/5/2012)

    I have 4 transaction tables that I wish to delete all the rows that have a date/time stamp of 12/31/2010 or less. Each table is about 60gigs before 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!

    March 5, 2012 at 12:27 pm

    #1454953

  • RE: SQL 2000 to SQL 2012 migration

    what he meant was your SSIS in 2012 can connect to any SQL 2000 instance, and thus do the database migration.

    no need to use DTS and then SSIS if SSIS...

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

    #1454748

  • RE: change initial size of tempdb

    sqlfriends (3/2/2012)

    Further experience on the production server, I found if I run the sql statement to change the file size, then I open ssms, it changed there, even 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 8:00 pm

    #1454415

  • RE: Function that returns the login of an AD Group

    also, these two extended procs examples might help.

    one tells you who belongs to a group, the other can tell you all the groups i belong to:

    EXEC master..xp_logininfo

    @acctname...

    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 2:39 pm

    #1454383

Viewing 15 posts - 5,836 through 5,850 (of 13,460 total)