Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 13,460 total)

  • RE: Auditing User Actions

    you could also consider a server side trace, with a filter on the HOSTNAME property to match the machine you want to watch

    the problem with that is it's possible 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!

    March 6, 2013 at 7:57 am

    #1593983

  • RE: SQL migration

    balasach82 (3/6/2013)

    what about using ssis to move logins

    or

    using management studio to script out logins and users (but it comes with default disable login option)

    SSIS has a Transfer logins Task 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!

    March 6, 2013 at 7:37 am

    #1593963

  • RE: SQL migration

    balasach82 (3/6/2013)

    Whats the best way to copy logins, users, logins with password along with exact status of enable/disable from source 2008 to destination server 2008

    Microsoft provides a downloadable query named...

    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, 2013 at 7:05 am

    #1593931

  • RE: Cursor.. cmds don’t seem to update until everything has finished

    inside a cursor, that's normal; what you want to do instead of print is raise a low level error inside via RAISERROR the cursor so you can see things...

    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, 2013 at 6:46 am

    #1593922

  • RE: On Error Do Next Query

    you could place GO statements between each command, but you still have to manually ignore the errors...makes it hard to determine which are "ignorable" errors and which are real.

    instead, consider...

    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, 2013 at 6:36 am

    #1593912

  • RE: The absolute basics of coding SQL Server in VB.net

    gary.p.heath (3/6/2013)

    I am trying my best to get my head around SQL Server but seem to be going around in circles. Everything I google is either way too complicated for...

    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, 2013 at 6:09 am

    #1593903

  • RE: How to stop Excel deleting leading zeros(SSRS -> Excel load)

    excel automatically treats anything that looks like a number as a number, dates as dates, etc

    I believe you'd have to change you report of the data to explicitly place 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!

    March 5, 2013 at 2:41 pm

    #1593657

  • RE: How to audit a single login

    grab it again; i edited it and retested it on my machine, it seems to work now.

    this is what i would use to review the trace:

    --SELECT * from sys.traces

    declare @TraceIDToReview...

    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, 2013 at 12:50 pm

    #1593622

  • RE: Alter User Defined Data Type

    as far as i know, you cannot alter a user defined type.

    you have to remove references to it, drop it, recreate it with a new definition, and then re-establish 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!

    March 5, 2013 at 12:40 pm

    #1593616

  • RE: How to audit a single login

    there's a couple of ways to tackle this, but it depends on what the focus is:

    if you want to absolutely prevent the login from UPDATE, you'd create a group,...

    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, 2013 at 12:08 pm

    #1593600

  • RE: View results into string

    it's not obvious where the alias goes;

    here's two examples:

    SELECT POPRCTNM,

    STUFF((SELECT ','+ CAST(ACTINDX AS varchar)

    FROM POP30390...

    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, 2013 at 11:24 am

    #1593582

  • RE: How to pass row to SQL CLR stored procedure ?

    a CLR has access to all tables in the scope of the transaction if you use the context connection; (ie #temp tables and @Tablevariables

    one option is to have the CLR...

    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, 2013 at 5:34 am

    #1593425

  • RE: Oracle trigger to SQL trigger

    That trigger emulates what a column with an identity does... so you can simply define the column as having an identity and skip the trigger completely.

    Create table tbname (colname int...

    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, 2013 at 4:44 am

    #1593409

  • RE: CLR Stored Procedures

    it's possible, but you have to register your DLL into the database as an assembly, before you can create a CLR which uses your Medical.DLL as a reference. You might...

    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 4, 2013 at 2:55 pm

    #1593181

  • RE: Automated Index Maintenance

    probably one of the best maintenance solutions out there is this free, peer reviewed, used in major production facilities and major companies solution offer by the world renowned SQL DBA...

    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 4, 2013 at 2:44 pm

    #1593178

Viewing 15 posts - 3,916 through 3,930 (of 13,460 total)