SQL Server

Page 423




  • Topics
    Replies
    Last post
  • Multi Select Parameter Problem
    by JohnJames
    3 Replies
    Last post by JohnJames
      • I have a multi-select parameter for a report, but If I select more than one value the report does not return any data. However, if only one value is selected data for that value is returned. I am using the IN option for the SP parameter. SELECT Code , Description FROM Product WHERE Code > 0 AND Description IN ( @Description ) I am using SP2 on SQL2005, also I do not have the
  • ownership chain doesn't work when acess cross database
    by stswordman
    8 Replies
    Last post by Raul Garcia - MS
      • i have enable cross database chain,but it return error message: The server principal "S-1-9-3-1149532189-1170944071-2610337685-3868961652." is not able to access the database "db2" under the current security context. I list the sql script as follows: Code Block use master ; go create database db1 ;
  • Mgmt Studio: List versus Details view
    by BobJ0101
    2 Replies
    Last post by BobJ0101
      • So now all the Details views have the "Policy Health State" column. Great. But when will we be able to add other columns to the details views Or at least put back what SQL 2K used to show in details views Pretty please
  • Transmission of compressed snapshots
    by aero1
    7 Replies
    Last post by aero1
      • I am using SQL2005 merge replication and have pull subscribers on a low bandwidth link I am compressing the snapshot into an alternate folder. Files are not put into the default folder When I start a synchronization, I would expect the cab file to be copied to the subscriber and then the files to be extracted locally at the subscriber in order to apply the snapshot
  • Is it possible to render multiple reports into a single report ??
    by S V Ramakrishna
    2 Replies
    Last post by S V Ramakrishna
      • Hi, I have an application wherein I need to generate a single report(possibly in PDF format) which contains more than one report. Iam using SSRS 2005. In my application Iam using report server url to render reports. The below is URL for rendering single report. http://servername/ReportServer/Pages/ReportViewer.aspx reportname&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aToolbar=t
  • Restore failed - the path H: has invalid attributes
    by TSloth
    4 Replies
    Last post by TSloth
      • Hi Hopefully someone can help me. I'm trying to restore my DB to a new server and also a new instance of SQL 2005 SP2+ hotfix KB934458. I've successfully restored my MSDB database and everything seems to be working fine, but now when I'm trying to do a restore of my Database RMc to the attached SAN, I'm getting the error: System.Data.SqlClient.SqlError: The path 'H:' has inv
  • DLL initialization failure using CDOSYS mail
    by GordonMoll
    4 Replies
    Last post by GordonMoll
      • We have a SQL 2000 stored procedure to send notification emails using CDOSYS and OLE Automation. It has been happily sending out emails for quite a while now from both of our dev and prod machines. The other day I added a line of code to format the message body variable. I tested the change in a T-SQL script in dev, then added the line into the procedure and recompiled it in dev using an
  • Error importing data from oracle database to an SQL database
    by cristms
    14 Replies
    Last post by Mali Buda
      • Hi! When i was importing a database table from an Oracle Database to a SQL database table, the wizard returns this error: Could not connect source component. Warning 0x80202066: Source - VB_PERMISSIONS [1]: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Chang
  • Performing insert / update queries using Pocket PC / SQL CE
    by jonellison84
    12 Replies
    Last post by Sunil Rathore
      • I'm writing an application for Windows Mobile 5 / Pocket PC using VB.NET 2005. The database is connected using an instance of SqlCeConnection and updated by an SqlCeCommand. The application can perform select queries on data originally entered into the database through Visual Studio, or perform update / insert queries at run time. Anything inserted or updated can be returned by a select query whil
  • Join-Problem (select two columns out of one column)
    by SPeters
    14 Replies
    Last post by SPeters
      • Hi I'd like to select two columns out of one column from another table. Example from source table: Code Block ID ArtNr EAN 1 4711 51323135 1 4712 84651213 1 4713 84351322 2 4711 86431313 2 4714 23546853 1 4714 54646545 2 4715 64684353 2 4716 65435132 I want to join this table to a base table with one select, and generate the following output. The ID identifies If
  • Administrator access Lost
    by sog
    1 Replies
    Last post by Bryan O
      • Hello, I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machin
  • Can't create fulltext index
    by msobik
    5 Replies
    Last post by IcedFrost
      • I'm about ready to smash my computer. I've installed SQL Server 2005 Express Edition with Advanced Services on Win XP Pro SP2. I made sure to enable the Fulltext service at install. Installed to the default instance name, and made sure the fulltext service is running from the CM. I made sure to enable full text indexing on my database from the properties window. I can create the fulltext catalog,
  • Can not create SQL Mobile database on server: the operating system does not support encryption
    by dbixby001
    12 Replies
    Last post by dbixby001
      • I have code that creates a SQL Mobile database on a server. It has worked in many environments, but I have one customer experiencing an issue. It will not create the database on their server. I would appreciate any thoughts. The exact error message I get is "the operating system does not support encryption" I am getting it on the line: SQLCeEngine.CreateDatabase()
  • Number of reads in Profiler is not the same when running the same SP on different PCs
    by ALEXTT
    5 Replies
    Last post by ALEXTT
      • I'm running the same query on two different PCs and tracing results in Profiler on my PC. When executing the query on PC1 - the total number of reads is 200000. When executing the same query on PC2 - the toal number of reads is 13000. It is almost 15 times more reads when executing query on PC2. The executed query is same on PC1 and PC2. Any reason for this I'm trying to analyse that query
  • Proxy account security.
    by DBLearner
    2 Replies
    Last post by Sandrine
      • Hi experts, Is there any potential security threat using Proxy accounts in SQL Server 2005 If any , Please give URLs for reference. Thanks, DBLearner
  • Reporting Services - statistics
    by fafnir
    5 Replies
    Last post by ?®€?§Q?
      • Where can I find statistics (if it is publicly available) on how many companies worldwide are using SQL Server Reporting Services
  • differences in SSIS file locations in SQL Server Agent step
    by Hubajube
    3 Replies
    Last post by jwelch
      • When adding an SSIS step to a SQL Server Agent job, when selecting the location of a config file, the dialog lets you select from the database server you're working with. If selecting the location of the package itself (when the source is File System), the dialog lets you select from the machine where Management Studio is sitting instead of from the database server. Is that intentional And if so,
  • Slow queries in SQL Express
    by hmahy
    4 Replies
    Last post by hmahy
      • Some queries take a long time to complete. Setup is: - SQL Express SP2 - Windows Vista Business - 2 GB RAM - Core 2 Duo processor - Connecting to (local) server with SQL Authentication - only 1 Instance of MSSQLSERVER Simple queries (SELECT * FROM TableName) wher the table has only a few records. This query may take up to 30 or more to execute. This slowness is consistent
  • T-SQL Trigger challenge
    by Batikit
    4 Replies
    Last post by Batikit
      • I have a customer table that contains ID (string), Company (string) that are set to NOT Nulls However , when inserting empty string '' into the table, the NOT Nulls accept it because it is an empty string. So, I want to create a trigger to check if ID or Company contain zero length value (empty string), then raise error "Sorry please enter ID" and do not execute insert As I am
  • SQL Server Profiler on SBS 2003 R2 Premium
    by NJMHBS
    3 Replies
    Last post by Samuel Lester - MSFT
      • Ok, I have installed SQL 2005 in about 10 or so production environments and have SQL Server Profiler installed and working on 2003 servers, but I cannot get Profiler installed on a SBS 2003 R2 Premium server. Does anyone know how to get Profiler installed on a SBS 2003 R2 Premium server TIA, Nick
  • problem with report viewer
    by shamen
    0 Replies
    Last post by shamen
      • Hi, I used report viewer to view a report that I have already deployed. But I get the following error massage. The path of the item "/Partner Reports/CDs - Accepted by Partner CU " is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) Does anyone know how to fix this Tha
  • Convert varchar to date on a column
    by Doug DeBug
    7 Replies
    Last post by Doug DeBug
      • I have a table with a column defined as a nvarchar.  The strings contained in the columns are in the form of YYYYMMDD.  I searched the forums here and believe that if I have a date as a string then YYYYMMDD is the correct format for a date stored as string.  However, I think I need to store the date as a Date type for selecting, sorting, searching, and indexing.  What
  • using alias in a view
    by Alvin Kuiper
    4 Replies
    Last post by Alvin Kuiper
      • Hi How (if i can) can i use a alias in my view if i have 1 alias total and a alias Moms can't i then have a nother alias there say total+moms Or shall i write all again in another alias Alvin
  • OUTER JOIN plus split? - how to?
    by mtm81
    3 Replies
    Last post by mtm81
      • Hi, I have two tables.. one has a list of the UK postcodes.. well..it's actually the districts.. so it's the first two three or four characters (basically all UK postcodes are one or two letters.. then one or two numbers.. then a gap.. and then some more info) So my first table has everything "before the gap" in seperate records. My second table is full of exact postcodes
  • Analysis Services Role Disappears Following OLAP Cube Nightly Rebuild - Project Server
    by Chasquad
    14 Replies
    Last post by Chasquad
      • Hello Everyone! People are not able to access the Portfolio Analyzer in Project Server (cube does not exists or you do not have permissions error) unless there is a role created in Analysis Services. If I add a user role to Analysis Services, then the users are able to connect. The problem is that after the cube rebuilds (which happens every night automatically - driven by Project Serv