Forum Replies Created

Viewing 15 posts - 7,711 through 7,725 (of 13,460 total)

  • RE: Database slow sql server 2005

    use the DMV's to determine the slowest query currently in the cache. examine the queries to see if they can benefit to from being rewritten to be more SARG-able, or...

    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!

    April 17, 2011 at 11:14 am

    #1312517

  • RE: Sqlserver 2005 doesn't send mail when i used free version .

    mail functions are based on the service broker functionality, which is not included in the express versions of 2005/2008; you'll want to buy a developer version for under $50 dollars...

    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!

    April 16, 2011 at 5:38 am

    #1312432

  • RE: sp_send_dbmail returns with no errors when @copy_recipients is not supplied, but does not send message

    could it be a relaying/mail forwarding problem? are you supplying a username and password for the AUTH command for your mail server?

    is the first destination email going to an...

    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!

    April 15, 2011 at 4:30 pm

    #1312390

  • RE: Login failed after database offline

    i believe you want to change the default database for that login to master or some other database, now that the original default database for that login is removed.

    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!

    April 15, 2011 at 4:20 pm

    #1312388

  • RE: How to find a temporary table in tempdb?

    the name field doesn't have the name like you think: it usually has a ton of underscores plus a unique numbr

    try this instead:

    select name, object_name(object_id) As ObjName,*

    from tempdb.sys.objects

    where...

    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!

    April 15, 2011 at 1:23 pm

    #1312317

  • RE: ENCRYPTION/DECRYPTION - SQLSERVER 2005

    this is just a guess, but AES encryption would match that format, since it can be stored in a varchar instead of varbinary field...but how does that help at 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!

    April 15, 2011 at 1:09 pm

    #1312314

  • RE: Database level trigger on delete,update operation

    ok... DML triggers for INSERT/UPDATE DELETE have to be on each individual table, i believe; DDL events can be captured on a per-database or per server. so I believe 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!

    April 15, 2011 at 1:01 pm

    #1312313

  • RE: Salesforce attachments stored as binary data needs to be rendered viewable.... help!

    Lowell (4/15/2011)

    it depends on what you mean by viewable;

    see this forum post on examples of how to

    RE: How to retrieve Image file from a SQL Table

    Sean Lange provided 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!

    April 15, 2011 at 9:45 am

    #1312231

  • RE: Salesforce attachments stored as binary data needed to be rendered viewable.

    it depends on what you mean by viewable;

    see this forum post on examples of how to

    RE: How to retrieve Image file from a SQL Table

    Sean Lange provided a fine...

    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!

    April 15, 2011 at 8:44 am

    #1312184

  • RE: USers and DML statement count

    i have a DML trace running all the time, which is recreated by a startup proc whenever the server restarts.

    i then also create a view which points to the trace,...

    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!

    April 15, 2011 at 7:12 am

    #1312108

  • RE: users exist on dev database

    <-- i saw what you did there lol

    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!

    April 15, 2011 at 6:39 am

    #1312078

  • RE: Retrieve mail box attachments of the server

    via TSQL, no; you end up having to create and call something external

    Whether an application which connects via POP3 and downloads messages and their attachments, it's going to happen external...

    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!

    April 15, 2011 at 6:36 am

    #1312076

  • RE: Kannada font is not displaying in Microsoftreportviewer in ubantu OS

    I'd have to assume that just like Windows, if the font that was selected does not exist, it defaults to some other font; I'd expect taht that might be 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!

    April 15, 2011 at 6:26 am

    #1312070

  • RE: In SQL 2000, security login inquiry

    if an application explicitly codes the "Workstation Id = " section to a connection string, then you can blank or or spoof the values you might expect:

    here's a connection...

    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!

    April 15, 2011 at 6:17 am

    #1312065

  • RE: How can I load the data in the local server into one remote server?

    you can use the EXECUTE AT feature of a linked server to create a table, then use an insert with 4 part nameingo convention to put local data 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!

    April 15, 2011 at 6:02 am

    #1312056

Viewing 15 posts - 7,711 through 7,725 (of 13,460 total)