Forum Replies Created

Viewing 15 posts - 5,341 through 5,355 (of 13,460 total)

  • RE: What system databases do I need to backup?

    something to keep in mind: system databases cannot be restored from previous versions or servicepacks;(regular databases are no problem)

    so say you backed up master, msdb and model in RTM (release...

    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!

    June 21, 2012 at 12:05 pm

    #1504134

  • RE: DML Trigger

    Sean Lange (6/21/2012)

    Looks like Lowell and I were typing at the same time. 🙂

    yeah but your answer is actually better; least amount of access is the best;

    my example was 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!

    June 21, 2012 at 11:33 am

    #1504117

  • RE: DML Trigger

    ok, what you want is possible, but it's the wrong way to do it;

    access should be handled via roles, and not at the dml trigger.

    it's much, much easier to create...

    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!

    June 21, 2012 at 11:28 am

    #1504112

  • RE: Problems with Varchar in Sqlserver 2005

    ahh, since it is parameterized, what are the datatypes of @PolicyNo and @EffDate?

    for parameters, you do not need the quotes if the parameter is the right datatype...maybe it's...

    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!

    June 21, 2012 at 7:18 am

    #1503910

  • RE: Import data from Active Directory Security Groups using SSIS

    i'm not an SSIS guy by any means, but a script task that hits the extended stored procedure xp_logininfo might be a little easier:

    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!

    June 21, 2012 at 7:06 am

    #1503907

  • RE: easy way to extract data to csv?

    another option is this suite of CLR export functions I created and put on codePlex as a proof-of-concept:

    https://sqlclrexport.codeplex.com/

    here's the example code of exporting a table to a CSV report:

    EXECUTE...

    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!

    June 21, 2012 at 6:15 am

    #1503882

  • RE: Problems exporting collapsible data functionality to Excel

    are you sure excel even supports a show / hide collapsing functionality?

    I've never seen it; i think that is a property of html pages 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!

    June 20, 2012 at 2:54 pm

    #1503686

  • RE: SQL Server Import and Export Wizard - Writing a SQL Statement, how to link to excel?

    this is a working, tested example of openrowset on an excel spreadsheet for a 64 bit installation of SLq server.

    you need to know the name of the spreadsheet in 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!

    June 20, 2012 at 1:03 pm

    #1503650

  • RE: SQL + PGP = head aching

    well it seems pretty easy as i'm slapping together a CLR;

    gota basic syntax issue for when it comes to full file names:

    for the switches, do any of these look correct?...

    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!

    June 20, 2012 at 8:28 am

    #1503474

  • RE: SQL + PGP = head aching

    another quick question:

    pgp --decrypt report.doc.pgp --passphrase Pa55w0rd

    does that create the file report.doc or return a bytestream/filestream?

    maybe there is an optional param for output file name like the encrypt command?

    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!

    June 20, 2012 at 7:53 am

    #1503431

  • RE: SQL + PGP = head aching

    lol I'm the opposite, clueless when it comes to PGP, but well versed in Sql Server, .NET and CLR.

    can you give me a pair of examples on the command line...

    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!

    June 20, 2012 at 6:50 am

    #1503372

  • RE: SQL + PGP = head aching

    it sounds like you are looking for a CLR which can encrypt/decrypt a file to disk using PGP;

    my Google-Fu pointed me to this thread from 2007 about SecureBlackbox , which...

    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!

    June 20, 2012 at 6:14 am

    #1503355

  • RE: Count Rows of a table Without using Count() Function

    the count of table rows are materialized in sys.indexes, and are accurate for the heap tables or clustered tables;

    that's the way to count rows quickly:

    SELECT so.[name] 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!

    June 20, 2012 at 5:45 am

    #1503340

  • RE: possible disable case sensitive in SQL 2K8 & R2?

    changing collation for all the columns can sometimes be a pain, especially if there are contraints or defaults on fields that are agetting their collation changed;

    things like CHECK columnname 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!

    June 20, 2012 at 5:34 am

    #1503335

  • RE: Results with no column headers

    Are you talking about when you copy/paste from SSMS?

    in Management Studio, it's an option you can turn on and off:

    Tools>>Options>>Query Results>>SQL Server>>

    Results To Grid has a checkbox for "Include...

    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!

    June 20, 2012 at 5:29 am

    #1503333

Viewing 15 posts - 5,341 through 5,355 (of 13,460 total)