Answer Questions

• PugJ XML VS SQL server

  Hi All, I am just starting a big project which I expect to have a huge data. My question is : Can i use XML or I need SQL server. and What the limitation storage of XML. Thank you in advance. emind Definitely you'll want to use SQL Server! Here are just a few brainstormed ideas as to why you should use a relational database (not necassarily SQL Server) 1. Atomicity 2. Referential integrity 3. A ...Show All

• weathers2284 RUNNIG A JOB???

  I HAVE A PROBLEM,, I``ve just deployed a package into my server..it runs without problems from my SSIS.. but when i set a job with the sql agent and the package to it,. the job just fails .. why any solution please somebody help me!!! Hi,This is dinesh here.I need to create a job and schedule it in sql server 2005.But I dont find the sql server agent option under the database instance in the object explorer. I need to write a simple ...Show All

• Rur Report Project and Report Designer

  When we want to create reports for report server, we create a report project in Visual Studio.  However, is it possible to add a report project as a sub-project or a nested project in a Visual Studio solution   Does it matter Thanks! Similar to my original question, do we have to install SQL Server 2005 in order to design reports to be deployed to report server   That is, for a business analyst to create reports, SQL Serv ...Show All

• DirtBag123 Gettint error "product level is insufficient" - did full re-install of SQL 2005 Standard Edition

  Installed SQL Server 2005 Workgroup Edition on a new server for testing. Installed SQL Server 2005 Management Studio on local PC. Created a database with a single table. Trying to run SSIS and export the database to a flat file. Get the error 0xc007470fe: Data Flow Task: The product level is insufficient for component "Destination - dbexport_txt [25]" I then installed SQL Server 2005 Standard Edition on the server as an upgrade of the existing ...Show All

• BStrick conversation groups and processing in order on the target end

  Is there any way to ensure that messages sent on different dialogs have the same conversation group id on the target queue   I was attempting to set the conversation group id on the dialog before sending but learned that this only works on the initator end.   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=174976&SiteID=1 I have messages that could be sent from different applications (and at slightly different times) th ...Show All

• Wayne Pfeffer Trying to create a Maintenance Plan through SQL Management Studio kicks SSL error

  SQL Server 2005 Beta 2, fresh install onto Server 2003.  When I try to create a new maintenance plan, it throws the following error: TITLE: Microsoft SQL Server Management Studio ---------------------------------------- Exception has been thrown by the target of an invocation. (mscorlib) ---------------------------------------- ADDITIONAL INFORMATION: An OLE DB error 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Se ...Show All

• Barzot MS Access upsizing to MS SQL Beginner

  Hi, I just built a site and found out that the hosting company does not support MS Access, but does support MS SQL ODBC. I have never used MS SQL, nor know how it works. I followed the directions to upside my MS ACCESS DB to MS SQL DB and I am waiting on a login and password from the hosting company. Do I have to have MS SQL software on my computer for it work Do I need to keep my computer online in order for my site pages to connection with ...Show All

• Arne Grant on all tables

  Hi, is there a way to grants object privileges on all tables of database to an user like this: grant select, insert, update, delete on <all tables> to usernamedb go thanks!!!! No. You can add user to db_datareader and  db_datawriter roles. This will however provide SELECT, INSERT, UPDATE and DELETE permission on tables/ views / table-valued functions etc. See Books Online for more details on the permissions / roles. Also ...Show All

• Alasdair Anderson Is it possible to modify column data type of view

  The SQL Server Management Studio shows the data type of each column of views. I am wondering how SQL server determines the types since my SQL code of views does not specifiy data types for any columns. I am much more interested in knowing whether the data types can be modified. Could anyone offer some hint Thanks, hz SQL Server uses the underlying schema information to do so unless you don’t specify a different data type than the ...Show All

• Sergey Golovkin It seems SQL editor do not support "Format" function. Is it right?

  When I write SQL command in the editor, I can not find a menu to format my command. Also the "Format Document" function in VS2005 Beta2 seems do not delete blank rows. I found a good Format tool here. I realy hope MSSQL 2005 has build-in function like that. http://www.sqlinform.com/ ...Show All

• eb1959 BadImageFormatException in tablet application

  I'm currently developing a tablet application which uses SQL Mobile 2005. I added the reference to the System.Data.SqlServerCe DLL and copied all the necessary DLLs of the SQL Mobile SDK (from the Program Files\Microsoft SQL Sevrver 2005 Mobile Edition\Device\Mobile\v3.0\tablet directory) to my output directory. But when my code hits the first SQL Mobile related line: SqlCeEngine dbEngine = new SqlCeEngine (); I get an BadImageFo ...Show All

• pieaholicx Problem getting execution status of a SQL Agent Job

  I’m having trouble retrieving the execution status of a job – perhaps someone can help me. I have a stored proc (on SQL 2005) that dynamically creates and executes a SQL Agent Job.   The stored proc first has to check whether the job exists.   If it already exists and is not active then I simply reuse the existing job.   However if the job exists but is currently executing then I need to create a new job because there can be ...Show All

• thatsalok Connection to Oracle

  I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source. Reports off the SQL Server Data Sources arerunning fine. Can any one out there help me out on this. I will really appreaciate. Regards, Sam. I'm trying to use the Oracle instant client on my report se ...Show All

• Prasa how is top % filter used?

  ok question was stupid i know. i still want to know how the filters work and an example for each filter option would be great. why can't all documentations be like msdn library the  built-in documentation shipping with reporting services is just too advanced for moi. I asked the question because the expression i wrote did not work so thought there was something wrong with my syntax. I finally found out ...Show All

• Ovidiu Cucu Reg Database design

  I am wondering whether this is the right forum, if not please provide me the details of the correct forum where I can post this question. I am trying to design a data base for a document request tracking system. The users request documents as hard copies in various sizes, color/b&W., soft copies in various formats that may be checked out with a chekin date. Now how do I create the tables for this My current design is to have a table fo ...Show All