Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 13,460 total)

  • RE: Finidng which stored proc causes the error ?

    mw112009 (1/27/2014)

    We have a commercial app that fires several stored procs at the begining. Now sure which one of them is throwing an error ( Says something like column ferral_orr...

    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!

    January 27, 2014 at 8:21 am

    #1683574

  • RE: Each Row Into a TEXT file

    if this is a one time report/export, you can select the data in ssms and chose results to text instead of to grid.

    otherwise,

    bcp.exe or sqlcmd, either using the -o parameter,...

    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!

    January 24, 2014 at 1:23 pm

    #1683250

  • RE: DataBase Mail Not Working

    my example trigger, while untested, would not error out if an automated process inserted multiple tickets in a single operation; but it would create a single email that said these...

    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!

    January 24, 2014 at 11:32 am

    #1683225

  • RE: DataBase Mail Not Working

    well, now i see two things;

    first is a critical permissions issue:

    the end user who inserts into this table must ALSO be a user in the msdb database, and must also...

    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!

    January 24, 2014 at 9:23 am

    #1683181

  • RE: DataBase Mail Not Working

    well, what you are seeing in the log is normal, i believe. if the service broker gets an email, it starts the database mail executable,and it's default lifetime is ten...

    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!

    January 24, 2014 at 9:00 am

    #1683163

  • RE: DataBase Mail Not Working

    since dbmail is already set up adn running, it might be something related tot eh recipient or relaying;

    if you run this query, is the specific email you sent 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!

    January 24, 2014 at 8:16 am

    #1683142

  • RE: Performance on Computed Columns

    nothing beats actually seeing it for yourself.

    here's exactly what i did.

    for computed columns, the cost isn't a lot, but it's there.

    the key is to look at the actual execution plan.

    attached...

    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!

    January 24, 2014 at 6:44 am

    #1683118

  • RE: Database corruption - inconsistant results

    Matt Crowley (1/23/2014)

    It might be OK. I remember in SQL 2000, if you ran DBCC checkdb against a database that was actively being updated, there was a chance you...

    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!

    January 23, 2014 at 1:18 pm

    #1682915

  • RE: Migration from 64 bit to 32 bit

    so glad it worked out for you;

    just got back from lunch, and i was just about to reply that i think you might have put a space between the slash...

    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!

    January 23, 2014 at 12:58 pm

    #1682907

  • RE: Get data from field in a previous record

    aberndt (1/23/2014)

    Lowell - You are correct, the SEQ is a number and the information that I want is associated with the SEQ # directly before that operation. I attached...

    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!

    January 23, 2014 at 12:07 pm

    #1682897

  • RE: Cannot connect to instance after disabling account

    i love this script from Microsoft for this kind of situation:

    http://archive.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=addselftosqlsysadmin&DownloadId=9198

    it connects to your local or named instance, and adds the current windows user as a sysadmin on the machine...

    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!

    January 23, 2014 at 11:58 am

    #1682894

  • RE: Get data from field in a previous record

    aberndt (1/23/2014)

    I appreciate both of your help. It is the row above in both the abc table and the view. I am reviewing the article that Brain Donor...

    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!

    January 23, 2014 at 10:40 am

    #1682872

  • RE: Get data from field in a previous record

    aberndt (1/23/2014)

    I am trying to add a field to a view that actually contains data from the record previous to the one I am selecting here:

    SELECT ...

    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!

    January 23, 2014 at 10:23 am

    #1682868

  • RE: Migration from 64 bit to 32 bit

    jeandlauro (1/23/2014)

    I will try that. I have also tried to instal the 64-bit access driver but get this message.

    http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

    Engine 2010 because you currently have 32­bit Office products 

    installed. If you want to install 64­bit Microsoft Access Database 

    Engine 2010, you will first need to remove the 32­bit installation of 

    Office products. After uninstalling the following product(s), rerun 

    setup in order to install 64­bit version of Microsoft Access Database 

    Engine 2010:

    Microsoft Office Professional Plus 2007, Microsoft Office Access 

    database engine 2007 (English)

    I've found the hard way there are multiple prerequisites 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!

    January 23, 2014 at 10:16 am

    #1682866

  • RE: expression invalid swtich case

    the SUM(SUM( doesn't look right to me; i think you just wnat to add the two together:

    does this minor change work?

    = "Record contains "

    + Switch(

    Sum(Fields!FQ.Value, "ds") <> 0 and...

    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!

    January 23, 2014 at 9:00 am

    #1682842

Viewing 15 posts - 2,626 through 2,640 (of 13,460 total)