SQL Server

Page 4278




  • Topics
    Replies
    Last post
  • soap message exchange between .NET Webservice and stored procedure
    by pamelia
    14 Replies
    Last post by pamelia
      • Hello, is message exchange between a .NET Webservice and a SQL stored procedure possible And if, could you please explain me how Or give me a tip where i can get more informations and maybe samples thanks for your help regards pamelia
  • Shared Connections and Stored Credentials for Subscriptions?
    by Dick Campbell
    8 Replies
    Last post by Dick Campbell
      • I can't seem to get this to work and have to resort to a custom connection for each report in Server Manager. The problem with that is that I have to re-do it every time I re-deploy the reports. Is there a secret to this that I have not found yet Dick Campbell
  • T-SQL / varchar truncate solutions
    by mrledbet
    2 Replies
    Last post by mrledbet
      • Why does SQL Server truncate the data being stuffed into "@vt" without throwing some kind of error or warning The print statement puts "123456" into the output window. Believe it or not .. our development team is actually trying to use this minor issue as justification for going with Oracle on this project, because they deem this as a data integrity issue and PL/SQL does
  • Data Flow Task Stuck
    by Corey M.
    7 Replies
    Last post by Jeremy D.
      • I have a simple data flow task setup... 2 ADO.NET connection managers, each referencing a DSN pointed to a Unidata database. 2 DataReader sources, each using a single ADO.NET connection managers, running a simple SELECT statement from a table. I have a Union All transform setup to merge the data and write to a OLE DB Destination (SQL05 database) When I run the package, each source w
  • Reporting Services Preview View different from Print Layout
    by Lukebe
    0 Replies
    Last post by Lukebe
      • I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic.
  • Delete row where a particular field value is not in a list
    by ctallos
    3 Replies
    Last post by ctallos
      • I have a table which has a field called filename, thus the data in the field would look something like this: FileName.doc FileName.txt FileName.foo I need to delete several rows from this table where the filename field DOES NOT contain the following extensions (e.g. row with FileName.foo would be deleted): .txt .pdf .rtf .doc .htm .html .mht .mhtml .dot .wk1 .wk3 .wk4 .xls .xlw .asc .olk
  • SSRS Performance
    by Purva007
    0 Replies
    Last post by Purva007
      • Hi All, I am facing an issue while working with huge data in tables. I have a stored procedure which when exceuted on SQL Server Browser takes little time to display the output on the screen. The same stored procedure is used by the application with SQL Server Reporting Services to generate the report. When executed, the application stops responding after sometime.
  • Does fragmentation changes after backup/restore operation?
    by Liquidloop
    3 Replies
    Last post by Peter Byrne MSFT
      • Hello, If i backup a database and then restore it, would physical structure remain the same specially fragmentation. I'm concerned about output of DBCC SHOWCONTIG. Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost Thank you. STG Labs
  • sp_spaceused equivalent in CE?
    by stu6008
    2 Replies
    Last post by stu6008
      • I am looking for a way to programatically determine the size of the data contained in a table, much like the sp_spaceused proc in SQL Server. Thanks.
  • Wat's the effective way to improve performance in table using indexing?
    by Hans1982
    5 Replies
    Last post by azz
      • Hi guys , assuming there's a table called 'transactions' which contains more than 1 million records and normally will retrieve the records for monthly/yearly summary report. There are 5 fields within the 'transaction' table which are : - transaction_ID (PRIMARY) - transaction_Name - transaction_Date - transaction_Amount - transaction_reference Right now I would like to add indexi
  • How to verify installed license
    by Skip Berry
    3 Replies
    Last post by Jens K. Suessmeyer
      • I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals. Thanks, Skip Berry
  • How to rename a column or table on the desktop?
    by dreamfly
    3 Replies
    Last post by dreamfly
      • I am using the compact edition on a desktop using VS2005 as well as SQL Server Management Studio. None of those tools allow me to rename a column or rename a table. Can someone point me a tool the runs on the desktop (as opposed to running on a CE device) that allows me to do the renaming Thanks
  • CAB Files
    by FarnazB
    1 Replies
    Last post by ErikEJ
      • Can anyone Please point me to a place that I can find some documentation on what the sql.ppc.wce5.armv4i.CAB does I basically need to know which files are being placed in the handset by deplyoing the CAB file. Thanks, Farnaz
  • Executing an SSIS package containing Analysis Services from ASP.NET
    by blued555
    6 Replies
    Last post by blued555
      • I'm trying to execute an SSIS package from an ASP.NET web page. Using some code from http://msdn2.microsoft.com/en-us/library/ms403355.aspx I have managed to get this working when executing a package that contains a stored procedure, however it does not work when there is an Analysis Services cube to build. Here is my code for the webservice Code Snippet Public Class
  • Upgrade SQL 2005 Standard to SQL 2005 Enterprise
    by Andy1099
    12 Replies
    Last post by Andy1099
      • Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place.
  • SQL Reporting Services performance on navigation pages.
    by Ray Dodson
    12 Replies
    Last post by dribar
      • I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources. In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the s
  • Determine if a column is indexed (and the index name)
    by rusag2
    3 Replies
    Last post by hunchback
      • Is there a slick way to determine if all the indexes (if any) for a particular field let's say: tbPeople ID (bigint) FirstName (varchar(50)) LastName (varchar(50)) I need to determine if [FirstName] in indexed anywhere, and if so, what are the name(s) of the indexes. thanks ahead of time.
  • Personalize Reports for Each User
    by rogupta
    4 Replies
    Last post by ?®€?§Q?
      • Hello Everyone, I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default. Thanks a
  • excel data mining add-in for categorical data
    by Manolis
    1 Replies
    Last post by Bogdan Crivat
      • Thank you very much for your previous answers conserning clustering algorithm. I change a bit my data and now I can get two and three clusters as I wish. But now I have a different question. I wish to keep my Structure and Model for further trials with different algorithm values, like cardinality. I tried the following I selected in excel Data Mining and then the option cluster butto
  • HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005
    by Emadkb
    14 Replies
    Last post by Charles Latham
      • SQL 2005 DOES NOT HAVE THE SAME FEATURE THAT WAS IN 2000 TO DELETE OLDER FILES OLDER THAN CERTAIN DAYS. I DO HAVE A JOB THAT CREATES A FULL DAILY BACKUPS BUT SINCE I DON'T HAVE ENOUGH SPACE, I WOULD LIKE TO FIND A WAY TO DELETE ALL OLD BACKUP FILES OLDER THAN X AMOUNT OF DAYS AND ALSO DELETE TRANSACTION FILES OLDER THAN X AMOUNT OF DAYS. IS THERE A TOOL TO DO THIS. CAN ANYONE HELP PLEASE. EMADK
  • Embedded image does not appear
    by Torsten_Katthoefer
    6 Replies
    Last post by larry smithmier
      • Hi there! I've an embedded image (logo) in my report, and in the preview it looks wonderful, but after deploy the logo doesnt appear in the report (report server). The url of the dead-link-image is http://hamsql1/Reports$BI/Reserved.ReportViewerWebControl.axd . I thought that an embedded image is stored "in" the report, but it seems to be an other place. Is it nessec
  • can't (re)start SQLServerAgent after changing its logon credentials
    by Guennadiy Vanine
    2 Replies
    Last post by Sue Hoegemeier
      • Since Copy Databas Wizard failed to copy anything from remote SS20005 (both are with SP2 3054) in any combination, I changed SQLServerAgent(myinstance_name) to run under Network from Local System with the help of SQL Server Configuration Manager For this change it was restarted, failed to start again and continues to be stopped giving "SQLServerAgent could not be started (reason: Unable to
  • I have a VB script that works in WinXP sp1 but not in WinXp sp2
    by mahsina
    2 Replies
    Last post by mahsina
      • hello all, I have the following script that does not work in windows XP SP2 //Script sub UpLoad (UploadFileName) dim b1 b1=&H4000000 set objStream =CreateObject( "ADODB.Stream" ) set objRecord =CreateObject( "ADODB.Record" ) set cnn =CreateObject( "ADODB.Connection" ) cnn.Open "provider=MSDAIPP.DSO;data source=
  • Correlated subquery in UPDATE - Where am I going wrong?
    by Menthos
    8 Replies
    Last post by Menthos
      • Hi, I'm sure I'm missing something obvious, but I'm trying to get the following update to work on SQL2000, but it keeps complaining about the where clause. UPDATE Table1 SET Col_A = t2.Col_A, Col_B = t2.Col_B FROM Table1 AS t1, (SELECT TOP 1 Col_A, Col_B FROM Table2 WHERE Col_C = t1.Col_C) AS t2 WHERE t1.Col_A is Null I'm fairly certain I can get it to work with a cursor, but that's n
  • Inconsistent OLE DB Failure when running SSIS packages
    by rsai
    5 Replies
    Last post by rsai
      • I have a series of SSIS packages which populate 12 different databases. Which data source & target they use is controlled by values passed down from the SQL Agent Scheduler Job Step using "Set Values" These values are passed to Variables which are used in the Expressions in the connection manager for the database to change the connection string and initial catalog. e.g. REPLACE