Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 13,460 total)

  • RE: LOGON Trigger and SQLCMD question

    just checking the basics...SYSUTCDATETIME() is SQL 2008 only...could it be the server you ran the script on is 2005 and the trigger is failing with invalid column 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!

    July 8, 2010 at 1:48 pm

    #1190475

  • RE: assigning default value to a column

    Paarth no, you can't assign a column value as a default...it has to be a constant or results of a function.

    i think you want to either use a calculated column(MyCol...

    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 8, 2010 at 10:52 am

    #1190379

  • RE: performance problem on Production and test servers but not on local development machines

    I'd also suggest looking at parameter sniffing and whether statistics are updated on the production servers as well...both of those things can lead to bad performance.

    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 8, 2010 at 10:00 am

    #1190346

  • RE: check if xp_cmdshell is enabled

    river i don't think you need to check it before hand , just change it...

    if xp_cmdshell is already enabled you just get this message anyway:

    Configuration option 'xp_cmdshell' changed from 1...

    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 8, 2010 at 9:38 am

    #1190333

  • RE: Script to automate the backup operation.

    that requirement reads like the person who wrote it already knows the answer/how to do it...this isn't a homework question or anything, is 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!

    July 8, 2010 at 9:25 am

    #1190322

  • RE: search based autorun

    http://en.wikipedia.org/wiki/AutoRun

    autorun is an option to call a specific executable on a CDROM, if the user has permitted it(registry settings are checked)

    so you could create an executable that is called...

    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 8, 2010 at 9:04 am

    #1190306

  • RE: Delete / Replace Blobs

    not sure on the space saving thing....is it that important to try and downsize the db?

    for the second part, if adding a column affects the application, i think you'd...

    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 8, 2010 at 8:18 am

    #1190271

  • RE: Query / Script to get the information if my domain account has access to all the SQL Servers in my domain.

    ok forget the do it yourself thing: download this free program:

    SQLRecon[/url]

    it will scan your entire network in a LOT of differnet ways, and find all installations, including multiple instances ont...

    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 8, 2010 at 7:13 am

    #1190218

  • RE: Query / Script to get the information if my domain account has access to all the SQL Servers in my domain.

    I would do this outside of SQL with either a sqlcmd , cmd script or an application. personally doing it in vb.NET is easiest for me, your milage...

    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 8, 2010 at 6:17 am

    #1190184

  • RE: how to structure this query(which is a view)

    niter can you show us the current query you are using? we can probably infer a lot from that, but the CREATE VIEW definition would help as well;

    the requrement looks...

    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 8, 2010 at 6:07 am

    #1190176

  • RE: Transferring Database Diagrams

    Twinsoft SME (7/8/2010)

    Have you try this code???

    Twinsoft is right...if you import the diagrams into a database that does not have the exact same object_id's, it fails with the same error...

    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 8, 2010 at 5:53 am

    #1190169

  • RE: Database Mail

    not sending externally is definitely a relaying issue, that was my point....it's not really a SQL issue anymore if you know you've already added everything for basic authentication. get with...

    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 7, 2010 at 3:40 pm

    #1189902

  • RE: Database Mail

    Terry this is a pretty common situation, and the issue has to do with relaying and your exchange server / mail server.

    mail servers are set up to avoid spam. 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!

    July 7, 2010 at 12:22 pm

    #1189799

  • RE: Backup 30 views without DB

    lets cover the basics, Andre, since this is your first post:

    a VIEW is a saved SQL statement...so if you have other views in the test database, you will need 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!

    July 7, 2010 at 12:11 pm

    #1189787

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

    Way to go Sean; eventually it'll be featured in an upcoming newsletter and get a lot of exposure.

    You put a lot of effort into putting it together, along with...

    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 7, 2010 at 10:12 am

    #1189724

Viewing 15 posts - 9,091 through 9,105 (of 13,460 total)