SQL Server

Page 4823




  • Topics
    Replies
    Last post
  • BCP on client machine
    by AnandaKumar.S
    3 Replies
    Last post by Arnie Rowland
      • Hi, What is the best practice to use BCP.exe to load text file from client machine to the SQLSERVER database installed in another server machine , without installing SQLSERVER client tools on the client machine . Any suggestions is appreciated. Thanks in advance. -Anand
  • foodmart database?
    by BlackStallion
    3 Replies
    Last post by jsmith
      • Where can i find the foodmart sample database for SQL Analysis Services 2005. thanks in advance.
  • SQL Server 2005 JDBC Driver v1.1 and SSL
    by Trevor McFetridge
    2 Replies
    Last post by Trevor McFetridge
      • Hi folks, I'm trying to figure out if the SQL Server 2005 JDBC driver supports SSL at all. I've downloaded the driver documentation, looked at more web pages than I care to count, and even went as far as to take a stab at guessing at different driver property names in the hopes I might discover some undocumented feature. Each time I try, I come up dry. The following exception shows up in my JBoss
  • Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0)
    by poekid88
    8 Replies
    Last post by Jason Smith - MSFT
      • I am using framework 1.0 to do the above tasks. Since there is no fileupload function in .net 1.0, i will be using the html control tools (file field) to do the upload option. i have totally no idea of how to start coding it...can anyone guide me through the steps thanks
  • compact sqlce database
    by Qiuwei
    5 Replies
    Last post by Qiuwei
      • Hi, there; I got a SqlCe2.0 database here called JOB.sdf, size is 260K. When I tried to compact it, it took very long and that JOB.sdf.tmp was created with 27.7M!!!, I can still open table in the database, but I found that there is some invalid data (unreadable square boxes). It looks like database was corrupted. My application gave error: Error Code: 80040E14 Message : The OLE DB Execute
  • Database design - best practices
    by Captain Rantflaps
    1 Replies
    Last post by Madhu K Nair
      • Does anyone know the location of an offical (Microsoft if possible) document that shows the best practices for databse design For instance what to call tables now schema's exist Should it be Countries LookCountry Geography.Country Geography.Countries What about Views and Stored procedures prefix with VW_ sp_ or some alternative Thanks
  • How do can I do this?
    by Alon *
    6 Replies
    Last post by Umachandar Jayachandran - MS
      • Hi, I have this table: colA ; colB 1) 1 2 2) 2 1 3) 2 6 4) 3 6 5) 6 3 6) 6 7 7) 7 6 and I need to select from it only the rows that do not have an opposite pair, i.e. only line (3) as it is 2 - 6 and there is no line 6 - 2, all the other lines have opposites, like line (1) 1 - 2 has line (2) 2 - 1 and line (4) has line (5), etc. any id
  • OLE DB Source to Flat File Destintation using Fixed Width Columns - determining source column width
    by theddern
    3 Replies
    Last post by theddern
      • Hi, I am trying to create a program that transfers tables to flat files. At this point in time, I have suceeded in created one that creates delimited files. However, I am now trying to create fixed-width files as you can do with the SSIS designer, but programatically. Is there a way to programatically determine the width of a column from the source table I can not seem to find any kind of function
  • date picker format
    by minority80
    5 Replies
    Last post by minority80
      • hi all, i've just updated my sql server 2005 with sp1 and sp2. i want my report date format to change according to regional setting, therefore i've set the report property for language as User.Language. how do i set the report parameter of type datetime to follow the format of regional setting my date parameter has default value which i query from a table. for e
  • Data disappearing during Run time
    by J_Dude2003
    7 Replies
    Last post by J_Dude2003
      • When I enter data into a SQL database and save it, the data that I have just added disapears, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay Any ideas
  • Old problem, but... Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
    by davidw
    2 Replies
    Last post by davidw
      • I didn't use SQL Express before, now I am trying to use it. I thinkk it is convinient if you just want to copy db files to user's machine. like this <add name="schsecurity" connectionString="Data Source=.\SQLExpress;Integrated Security=true;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" /> as long as user has sql express installed, he should be
  • Data Conversion
    by slash85
    6 Replies
    Last post by slash85
      • Hi, I have a flat file with over 300 fields and need to do a data conversion before SQL final destination, most fields are DT_STRING, is there an easier way of converting the data without having to manualy do the 300 fields. I have all the data types i want STR converting to in a file. Any info would be great, Cheers, Slash.
  • Results from Aggregate() are wrong
    by David Beavonn
    6 Replies
    Last post by Deepak Puri
      • The aggregate "Bad Agg" in the query below is causing no results to be returned. Notice that there are two members in the set of "Bad Agg". If I remove one or the other from the set (and create a set of just one member) then I get valid results. Does anybody know what might be happening We are on the latest SP (9.00.3042). Note that SP/LU below are the &qu
  • Inconsistent Linked Server Query Results
    by cdun2
    1 Replies
    Last post by cdun2
      • Hello, I have a linked server named 'Charlie_File' to an Excel Workbook that I set up in SQLServer 2005 Management Studio. The workbook is on my local C drive. Sometimes, I get the results back that I expect when I run the following query; SELECT * FROM OPENQUERY ( Charlie_file , 'SELECT * FROM [Feb$]' ) Sometimes, on subsequent runs of the above query, I get the following message
  • Can't get Dynamic Security working ...
    by jcurran
    5 Replies
    Last post by jcurran
      • I'm trying to get dynamic security working using a member property which contains a list of usernames that are allowed to access that level of the hierarchy. I'm using the following setup: Dimension: DynManager Hierarchy: DynManager Levels (in order): SVP, DVP, RVP, ROM, DDO, Store Attributes: SVP -> SVP Access List, DVP -> DVP Access List, RVP -> RVP Access List, ... etc
  • Sql Query to create nested XML Sitemap
    by Crossdelena
    13 Replies
    Last post by G. Marin
      • Hi Everyone, I am trying to create an XML sitemap file by running a sql query against a SiteMap Database. I am successful in creating the SIteMap file uptil one level deep but when the dpeth incereases the results go weird. Can someone explain where I am going wrong in the following code: Database query to built SiteMap: Code Snippet CREATE TABLE S
  • How Extract the data of TFINF when doing text mining? Thanks
    by jliu685
    1 Replies
    Last post by Jamie MacLennan
      • How Extract the data of TFINF when doing text mining Thanks
  • Passing SELECT ALL from URL
    by evaleah
    6 Replies
    Last post by Philippe Cand
      • Is there a way to pass the "select all" option to a multi-select parameter from a URL string Thanks, Eva
  • configure sql xml support IIS
    by nambo
    0 Replies
    Last post by nambo
      • Hope someone can help me...anything would be appreciated. I am using sql server 2000...When I open the Configure sql xml support IIS tool to create a Virtual Directory the only thing that shows up is a computer icon and a IIS Virtual Directory Management for SQL Server. I can't expand ... there isn't a default web site. The other tool called Enterprise Manager works fine with XP. Matter of
  • Clone new database from existing
    by RDuke
    6 Replies
    Last post by RDuke
      • How do I go about creating a cloned copy of an existing database on the same server I basically want to set up a test copy of a production database, but let it reside on the same server with a slightly different name, prefixed with 'Testing_". I typically just use Studio Express Manager and not scripts to do admin tasks. Here's what I tried that didn't work so well: * Had full backups of prod
  • How to restrict a custom component to be used only in the event handler tab?
    by spattewar
    6 Replies
    Last post by Kristian Wedberg
      • Hi, One of my plan is to develop a custom task compoent to log the errors into the destination provided as paramter to the component. Now how can I restrict the use of this component in the event handler tab only. can something like this be done Also extending this a little further, is the below thing possible The custom component should expose custom properties which should allow the use
  • catch me if you can / bug in the "bug"?
    by Bjorn D. Jensen
    6 Replies
    Last post by Jens K. Suessmeyer
      • Hello! Try this (-: BEGIN TRY SELECT * FROM NonExistentTable ; END TRY BEGIN CATCH PRINT 'catch me if you can' ; END CATCH ; /* results in: Msg 208, Level 16, State 1, Line 2 Invalid object name 'NonExistentTable'. statement not printet */ BEGIN TRY BEGIN TRY SELECT * FROM NonExistentTable ; END
  • Parameters in an OLE DB Command
    by ChrisHelt
    3 Replies
    Last post by ChrisHelt
      • Hello! Is there a way to use an OLE DB Command transform to execute the following SQL query "Select sum(length(" + @[User::varDBName] + ":informix.cyh_t.u_obj)) from " + @[User::varDBName] + ":informix.cyh_t, " + @[User::varDBName] + ":informix.cch_t where " + @[User::varDBName] + ":informix.cch_t.d_obj = {D '" + @[User::strQueryDate] + "
  • How to set the current connectionString user as a defualt value?
    by HSBF Lewe
    3 Replies
    Last post by HSBF Lewe
      • Hi, I'm using username & password in my connectionString to connect my program (C#.net) with Sql Server 2005.. I put in defualt value in one feild: user_name() it replace the user: dbo, not the user which I used in my connectionString . so.. how to get this user   I tried to put: currnet_user but I get the same result, " dbo " not the user in my connectionS
  • Generating letters in SSRS
    by arc_dev
    1 Replies
    Last post by Teo Lachev
      • Hi. I'm looking for tutorials on how to use SSRS 2005 to generate letters in Word or PDF format from a database. We need to send letters with our company logo and some boilerplate text to a set of companies based on a SQL Server query. So the letter will look something like this, with the red areas repeating from the dataset, [logo goes here] 123 Any St. AnyCity, CA 90210 [today's date] Dear