• sql data conversion error 91Object variable or with block variable not setExecuting sql

    Error 91 Description: Object variable or with block variable not setExecuting sql statementRetrieving division information from the sql data store. Checking for the core database. Source: AFWSvDataServices3Converter.ConvertergetSQLDivisions, converter.convertergetdivisions,...

    Dmb07125 pointsBadges:
  • how i do save picture in data base vb.net

    iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

    12345678900110 pointsBadges:
  • Textbox input to a a sql dataset table in Vb.net

    How do I input data from textboxes in Vb.net to ...a table in a  data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100

    Mace1005 pointsBadges:
  • SQL Script with hyphen in the value set

    We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last...

    Markmorgan475 pointsBadges:
  • Constraints (MySql,tables,null,PK,FK etc)

    Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

    Ak1bo78150 pointsBadges:
  • Email Notification

    Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...

    Keirameister5 pointsBadges:
  • SQL Server 2005 Legacy DTS fails when run as a job

    When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

    Ftornoe40 pointsBadges:
  • Msg 102, level 15, State 1, Line 102

    I get this with an 'Incorrect syntax' messasge when I run a stored procedure. if I run the 'offending' code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error 'moves' to a different location. HELP!

    TonyDyer5 pointsBadges:
  • Exchange/POP 3 service fails to start

    I have server 2003 and exchange 2003 running. I have a user that requires pop3 for mail. When I reboot the server, I get a warning that ? An error occurred while starting the Microsoft Exchange POP3 Service: server instance number 1 failed to start with error 0x80040a01 When checking the services,...

    KillerX0 pointsBadges:
  • Archiving Exchange 2007 in a SQL database

    How do you set up an SQL database/server to receive and store archiving/journaling for exchange 2003/2007 email.

    Cmoney5 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • what is different from MSSQL, MYSQL and Oracle 11g?

    what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

    Juna060615 pointsBadges:
  • Grant users rights to run reports on reporting services

    How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on...

    Cindyfiller45 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Find a particular text from all tables in DB.

    Hi There are 100 tables in my DB. I want to find if a text say "ABCD" is availbale in any these 100 tables. If it is availbale can we list those tables. Can someone help me out with the Query.   Regards Mayur

    Mayurkhe295 pointsBadges:
  • Where did the undocumented stored procedures go in SQL Server 2008 Managment Studio?

    Is there a way to see the undocumented stored procedures in SQL Server 2008?  They don't seem to show up in the explorer tree in Management Studio the way they did in SQL Server 2000's Enterprise Manager. I was able to run XP_FIXEDDRIVES but it doesn't show up in the list under stored procs in the...

    Brenbart5 pointsBadges:
  • How to pass a store procedure and a variable to a datagrid

    I am a newbie when it comes to passing parameters to a control. I am programing in VS 2008 using VB as the language. The grid is in an ASP.Net (3.5) page  I have set up a store proceduer in SQL Server 2005 as follows: CREATE PROCEDURE   usp_selEmpSSN--Transfer all records from tbl_CL with the...

    Neilo125 pointsBadges:
  • SQL Server 2005 error log, could not read information for this log entry

    Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   "Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:"   Has anyone seen anything similar? Does anyone...

    Db23290 pointsBadges:
  • Create Excel file on web server by using SQL

    How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure...

    SwapnilD25 pointsBadges:
  • Reporting Services 2005

    Hello, I am running reporting services 2005. I created a subscrition for a report named "paid_claims" that will auto generate an excel file into a shared folder on the network. The "paid_claims" report has a link to another report named "sub_paid_claims" in the same folder. We recently renamed our...

    Rick Martinez585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following