SQL Server

Page 5625




  • Topics
    Replies
    Last post
  • Katmai June CTP, where are the SSIS lookup enhencements
    by ccote
    2 Replies
    Last post by ccote
      • H, I downloaded and installed the June CTP of Katmai. It looks the same as SSIS 2005. I would have expect to see improvements made to lookups (connectivity, cache) but did not find it. Are these improvements into June CTP Thanks, Ccote
  • HOW TO EXECUTE THE PACKAGE IN STORED PROC PLZZZZZZZZZZZZZZZZZZZZZZZZZ
    by Koteswara Rao
    1 Replies
    Last post by jwelch
      • My Package Exist in C:\WROX\WROX\bin\excel_database package exist OR sql server agent ->job-> excel_database package exist now i want to excute the from master database how please send the stored procedure code Regards koti
  • Moving From DB2 to SQL
    by Constantijn Enders
    0 Replies
    Last post by Constantijn Enders
      • Hi, We want to move our current datawarehouse from DB2 to SQL server. Is there a tool who can do this automatic If not is there a tool that can convert the ETL in datawarehouse manager to SSIS Or at least ease the pain CE
  • Installing SQL Server Express
    by Jim Hess88
    10 Replies
    Last post by Mike Wachal - MSFT
      • I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything. My problem is that now that I have
  • Modifying Existing Rendering Formats
    by Jeffrey Rush
    2 Replies
    Last post by Jeffrey Rush
      • Good morning (afternoon/evening) all. I am researching a way to render data in a plain text file, with no formatting. I plan on building out the result set to exactly what I am wanting and just need it to render itself without any formatting logic being taken into consideration. The end result is to generate a QIF file from a random data set. QIF is just a formatted text file. Am I making sense
  • Data migration using Import/export wizard SQL 2000 to SQL 2005
    by Javahar
    2 Replies
    Last post by kumar s
      • I am trying to import data from SQL 2000 to SQL 2005 The Data schemas are the same in both (tables, relationships, key and triggers). Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 20
  • cluster install 2nd node unavailable
    by acki4711
    6 Replies
    Last post by acki4711
      • Hi all, Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown". - I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 v
  • Problem about ProClarity KPI indicator customization
    by Helen999888
    0 Replies
    Last post by Helen999888
      • Hi, all Microsoft BI experts here, Thank you very much for your kind attention. I am wondering if there is any way for us to customize the size of the the KPI indicators on ProClarity As this is a quite important issue if we could customize the size of each indicator, in many cases we would love to see very big indicators! Again, thought here is the best place I could think of to place this
  • It's a computed column processing bug?
    by Roman S. Golubin
    3 Replies
    Last post by Roman S. Golubin
      • Hello everybody! I have question about indexed and not indexed Persisted columns on sql server 2005. It's a bug First , my version of SQL Server is Microsoft SQL Server 2005 - 9.00.3186.00 (Intel X86) Aug 11 2007 03:13:58 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) Now I create two tables and try four se
  • Stupid Question in SQL Sever 2005 Report
    by Kaveti
    14 Replies
    Last post by Kaveti
      • Hi There I have a report built in SQL Server 2005 Reporting. When i run that report i see the output question is, if i want to copy any column data like for example on 10th record i want to copy 2nd column's data. How do i do that. I want to use mouse to copy data to Notepad like the normal copy and paste data. When i try to do that i was not able to clicl on it. I can't seem to get this do
  • SQL Query string (Probably easy)
    by Fireemt12
    3 Replies
    Last post by Dhericean
      • Need help with a query string. I know this doesnt exist, but logically this is what Im looking for. SELECT fieldname1, fieldname2 WHERE (fieldname1 LIKE ('%foo%', '%doo%', '%too%')) OR (fieldname2 LIKE ('%foo%', '%doo%', '%too%')) To make this clearer, or maybe someone else has a better idea, I am using code on a web page to search the DB. It takes the string entered by a user, say &qu
  • SSIS BULK INSERT error: File Format doest not exist
    by bjorke
    6 Replies
    Last post by Steve Wang 2006
      • My colleague is working on bulk insert task from SSIS and since the data file does not contain any valid delimeter one of the suggestion he got is to use a file format to address the issue. Thus a bcp command is used to generate the format file, as per below. bcp <database name>.dbo.<table name> format nul -T -S <server name> -n -f out.fmt The file file format was
  • MSSQL 2005 SP2 Upgrade Fails - DB Engine
    by Dwebs
    4 Replies
    Last post by Dwebs
      • Just downloaded and installed mssql 2005 sp2 on one of our servers All components upgrade apart from the database engine. After the first upgrade i rebooted then tried to update the db engine again it failed for a second time. Below is the error from mssql setup, any help would be nice! Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 10
  • update query? multi column key
    by fbecker
    4 Replies
    Last post by fbecker
      • Hi I have a question about an update query... I want to set every Tool (described by toolId and toolGroup) as active, which has the highest timestamp.. I have a table Tools with a composite key of toolID and toolGroup with following columns (actually it has more but for simplicity sake..)... toolID, toolGroup, tool_timeStmp, isActive I have a select query which shows me eve
  • sp_fulltext_database is unable to full-text index the current database
    by NipunTomar
    4 Replies
    Last post by NipunTomar
      • I am using-- exec sp_fulltext_database 'enable' to enable fulltext indexing on a database but query does not return any results, it just keeps on executing. I waited for about an hour and then cancelled. I dont know what is wrong. Can anybody please help me.... i am using SQL server 2000 on Windows Server 2003 SELECT SERVERPROPERTY ( 'productversion' ) retured 8.00.194 SELECT SERVERPROP
  • Cdate conversion vs data from a cube
    by Guillaume R
    5 Replies
    Last post by sluggy
      • Hello, I have a problem with date conversion when the date is coming from a cube. I mean the function "=cdate(Fields!Signature_Date.Value)" works fine when the date is always fill in, but when my record is equal to nothing, I have got the value "#error" in my report... Which is the best way to avoid to display this value in my report I have used the
  • Taking Data from another report?
    by Keith O.
    2 Replies
    Last post by Lisa Nicholls
      • Hey everyone, I am planning on running a weekly report on a database that has its data overwritten every day. If i wanted to compare current data to data from the previous week, is there a way to save this report's information or something so that I will be able to pull it back up Thank you.
  • Hidden Attributes in Report Builder?
    by tenchyz
    0 Replies
    Last post by tenchyz
      • I created a report model off of an Analysis Service Cube. And was checking out the report model with the report builder. Does anyone know if there is a way you can call hidden attributes into the report using Report builder
  • Reporting Service webservice access denied Exception
    by fbecker
    1 Replies
    Last post by h_w
      • I am running SQL Express with Reporting Services 2005 SP2. Installed both on with the NT-Authority\Network Service I uploaded a report and I can execute it in the Report Manager. What I want to do is execute the report via Webservice and stream the result as PDF. Code Snippet Reporting.ReportExecutionService svc = new Reporting.ReportExecutionService(); svc.Credent
  • check if there is an existing SQL server installation
    by reggiepangilinanX
    6 Replies
    Last post by Deepak Rangarajan
      • is there a way to check an SQL Server installation, i want to get the version and what edition the installed sql server is. thanks
  • Great Plains database replication
    by Robbie Page
    1 Replies
    Last post by Raymond Mak
      • Our company has a database server (Windows Server 2003 x64 EE w/ SQL Server 2005 x64 EE) that has Great Plains installed. We have a database for one of our companies that I would like to begin replicating to another server. The reason behind this is that we want to run the GP/CRM Connector which requires 32-bit ODBC connections. Anyways, what I need to do is enable replication to our 32-bit ser
  • Datatype nvarchar(max) not accessible
    by Werner Mielke
    2 Replies
    Last post by Werner Mielke
      • Hi, trying to input create table T ( c1 nvarchar ( max )); in MS SQL Server Manangement Studio Express results in an error : Fehler beim Analysieren der Abfrage. [ Token line number = 1,Token line offset = 30,Token in error = max ] create table T ( c1 nvarchar ( 4000 )); is processed w/o errors. I¡¯ve installed SQL Server 2005 Express Ed. SP2 Microsoft SQL Server
  • Referencing Variables by Name
    by Colin Macguire
    10 Replies
    Last post by Phil Brammer
      • Hi there everyone, A quick question. How do I reference variables (system and user) in SSIS by name instead of by just using a " ". The reason why I'm asking is because I'm trying to log what happens in a package to SQL, and if I cannot reference a variable by name it tries to insert variable values into incorrect fields An example of the code I'm trying to use can be found
  • Need to retrieve record count from CTE
    by Mark Shvarts
    5 Replies
    Last post by Rob Farley
      • I have a common table expression and I need to retrive first 20 records as well as record count. select @first_name='m', @last_name='s' with my_cte as ( select row_num = row_number() over (order by prosp_id, contact_num) , first_name, last_name from piza.prosp_contact where first_name like @first_name + '%' and last_name like @last_name + '%' ) sele
  • Ad hoc reports multiple tables
    by kutts
    1 Replies
    Last post by kutts
      • HI, i am a new to SSRS and i am facing a problem with Ad Hoc reporting. actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report. i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associat