Forum Replies Created

Viewing 15 posts - 9,136 through 9,150 (of 13,460 total)

  • RE: xp_cmdshell

    i have this saved in my snippets that might help...instead of a linked server you could loop back tot eh current server as well:

    SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY...

    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!

    July 5, 2010 at 9:50 am

    #1188823

  • RE: DBMail

    because you are getting responses form the mail server, you have everything set up almost perfect.

    in order to prevent spam, most mail servers prevent relaying(returning error 5.7.1 Unable to relay...

    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!

    July 5, 2010 at 6:11 am

    #1188754

  • RE: SQL 2008 DDL Auditing - A Full Self Installing/Updating Solution For Whole Server

    Sean nice job; you should submit this as an Article as well; it will get more exposure, plus some bragging rights for you as well...you can say you are "published"!

    way...

    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!

    July 5, 2010 at 5:58 am

    #1188748

  • RE: error in connection string

    c# uses double slashes to escape and mean a regular slash; it is interpreting \s to be a special char that doesn't exist; is new line, \t is tab,...

    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!

    July 3, 2010 at 12:16 pm

    #1188562

  • RE: Registered local Servers

    the SMO method is more robust; there is a IsLocal

    field in the set returning 0 or 1 for true/false if it is local;

    you could create a CLR to return...

    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!

    July 2, 2010 at 2:30 pm

    #1188430

  • RE: Registered local Servers

    here's one way via TSQL, but it requires osql and xp_cmdshell:

    CREATE PROCEDURE dbo.ListLocalServers

    AS

    BEGIN

    SET NOCOUNT ON

    CREATE TABLE #servers(sname...

    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!

    July 2, 2010 at 11:35 am

    #1188373

  • RE: Run Time Error 91

    google is your friend for Error 91:

    ukarlink (6/30/2010)

    Private Sub Form_Load()

    Dim cnThisConnect As NEW ADODB.Connection

    cnThisConnect.ConnectionString = "data source=YourServer;initial catalog=SandBox;user id=DaveTheDeveloper;password=NotARealPassword;Trusted_Connection=False;Application Name=SSCExample.YouApplicationName.exe;"

    cnThisConnect.Open

    Dim rcdCompanies As NEW ADODB.Recordset

    Set cnThisConnect = CurrentProject.Connection

    rcdCompanies.Open "tblCompanies", cnThisConnect,...

    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!

    July 2, 2010 at 10:59 am

    #1188363

  • RE: Execute .sql files to create table schemes

    from where? via TSQL in SSMS,SSIS, or command like via sqlcmd or maybe even an application like vb/vb.NET?

    TSQL is a little hard to do, because of security issues....would...

    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!

    July 2, 2010 at 8:54 am

    #1188257

  • RE: Print Procedure Parameter

    but when I print the results (PRINT @TABLEHTML), SSMS truncates most of the code especially when it gets more than a certain amount.

    this is a setting in SSMS; by...

    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!

    July 2, 2010 at 7:02 am

    #1188177

  • RE: Security to Run DDL statements only via SSMS

    freshcrop2010's post is Spam. Reported. No replies please. bot joined and posted within the same minute(second?) of the forum join.

    Joined: Today @ 12:43:26 PM (0 visits since)

    Local Time: 7/1/2010...

    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!

    July 1, 2010 at 11:50 am

    #1187832

  • RE: Storing a document in SQL

    there's another thread on a very similar subject today:

    Retrieving Large Videos

    15-20MB in a varbinary(max)

    that you should read...

    basically, the filesystem is almost always faster than SQL for storing...

    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!

    July 1, 2010 at 11:44 am

    #1187829

  • RE: Modelling relationship of order header to order lines of differing types

    i would just add a datetime field with a default of getdate to each of the 4 or 5 related tables...then i'd use a view to pull the common parts...

    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!

    July 1, 2010 at 6:26 am

    #1187617

  • RE: Modelling relationship of order header to order lines of differing types

    I've seen it done a few different ways...in Quicken for example, every item has a memo field, so an additional description can be added to each item; Also it's possible...

    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!

    July 1, 2010 at 6:03 am

    #1187604

  • RE: what are the roles and resposibilties on sql dba

    well...first there's different KINDS of dba's...developer dba work with code objects, and tuning, Server dba's(well that's what i call them) work mostly with maintenance/backups and tuning

    then there's the business analyst...

    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 30, 2010 at 7:25 am

    #1187052

  • RE: Is there a limit on the number of databases a maintenance plan can back up?!

    the only thing I can think of off hand is whether it was possible the server ran out of disk space after backing up the 30th database....when it moved 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!

    June 30, 2010 at 6:30 am

    #1187009

Viewing 15 posts - 9,136 through 9,150 (of 13,460 total)