Answer Questions

• SneakerXZ I need identity on updatable partitioned view

  Ok, already read that is not allowed to have identity column in any member table of a updateable partitioned view. But I need an identity column. Is there any other way or ide how to solve this problem I tried and resolved this problem using partition tables... With partition views this was impossible, (not impossible, but just too long and complicated, which in generall means a lot of bugs) This is one of the situation where using a column with a uniqueidentifier datatype, set to a default of newid() is the 'right' solution. create table bileta_te_lozura_2007_01 ( id int not null, databiletes datetime not null check ( databiletes > ...Show All

• enric vives Last SQL Statement run on SQL Server

  Hi All, Im just wondering if there is any way to get the last SQL Stmt or SP that was run on the server without using the SQL Profiler or third party software. Thanks and have a nice day to all. No. There is really no easy way to determine this information. And do you want last SQL statement or SP executed by any connection Or is it the last on the server In some cases, you could use DBCC INPUTBUFFER with the currently executing or inactive SPIDs but this is not entirely accurate. And if the connections have disconnected from the server then there is really no record. You could look at the cached plan entries but there is no way to relate them in order of time and you will miss statements that were no ...Show All

• fDogGT ODBC Driver for SQLServer Everywhere/Compact from Access

  So far I've been unable to connect to a test SQLServer Everywhere/Compact database with MS Access. I installed the new SQLServer 2005 Native Client to no avail. Has anyone done this The naming is a little tricky here...SQL Server 2005 Mobile Edition is the 3.0 version of the product formerly referred to as SQL Server Compact Edition (or SQL CE). The product formerly referred to as SQL Server Everywhere now appears to have the moniker of SQL Server 2005 Compact Edition...this version is the only one in this family that can be used on the desktop. A CTP version of this product was released in late August and the RC1 version is now available at http://www.microsoft.com/downloads/details.aspx FamilyId=85E0C3 ...Show All

• himanj Reporting Services Slow to wake up

  My users have been complaining that the first time they run reports on Reporting Services during the day it takes 30+ seconds for the first report to run. After this initial delay they respond very quickly. There is considerable interaction with the database through a client application prior to this so the server is not in a sleep mode. It appears to only be an issue with Reporting Services. Any ideas on how I can get this initial delay to go away Thanks in advance. If the user is accessing reports through Report Manager, reporting services relies on IIS to host it in an AppDomain. IIS will often take several seconds (duration depending on the current use and speed of the machine) to intialize ...Show All

• Puzzl3b0x Getting SQLDependency to fire the OnChange

  After many problems with permissions I have got got SQL to accept a notification request but the public static void OnChange(object sender, SqlNotificationEventArgs e) is never triggered. The notification registers and de-registers ok. The same connect string successfuly connects to the same database to process queries. I can see the GUID suffixed stored procedure, queue and service being created. Where does SQL2005 store the address/name of the routine it is to trigger (When the notification is cancelled, the guid-siffixed items disappear) I have looked at the generated stored procedure, queue and service, but there is no indication of what is to be called back. I have followed the instructions at http://msdn2.microsoft.com/en-us/library/ ...Show All

• TimClark Add a column to table from stored proc

  Hello all, I want to alter a table in a stored proc to add a column dynamically. I am passing the name of the new column to the stored proc param. Does anyone know the syntax for this Here is the code: CREATE PROCEDURE procAddNewOptionType -- new option type parameter @OptionName varchar ( 50 ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert new option type into list of types INSERT INTO dbo . tblClientOptionList ( strOptionName ) VALUES ( @OptionName ); -- alter client options table to add new column passed to proc as @OptionName ALTER TABLE dbo . tblClientOptions ADD @OptionName BI ...Show All

• RainerK Help with installing VS Tools

  Hi, I have a problem with the installation of SSCE31VSTools-ENU.exe into VS2005. The installation ended after a few seconds although in the event log there is information that the product is successfuly installed. However, when I run Visual studio there is no project under Smart Device regarding SQL Compact database or something similar (there are only templates for: device application, class library, control library, console application, empty project and nothing more) VS2005 is in this version 8.0.50727.762 (SP.050727-7600) In application event log there is: Product: Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 [ENU] -- Configuration completed successfully.'" Has anyone some idea if there is a ...Show All

• Gem2036 SSRS subscriptions with MOSS 2007

  We are working with MOSS 2007 RTM and SSRS CTP3 integration. In our setup, I have created a custom content type, based on Report, so that we can capture custom metadata associated with our SSRS reports. I added this content type to the report library, made it the default type, and added a report with this type. That all appears to be working correctly. My issue is that when I deliver content (PDF or Excel) to another document library (also with my custom content type as the default) from a subscription, none of the metadata from the report is associated with the delivered content (PDF or Excel). Am I missing something, or is this not possible ...Show All

• felicity1982 Viewing the Contents of a Stored Procedure

  Is there a way to view the contents of a stored procedure (MSSQL 2K) in the Query Analyzer maybe using system stored procedure K sp_helptext 'NameOfStoredProcedure' Thanks! I've been using the gui way too long. ...Show All

• George Clingerman Replicate or mirror

  Hi, Trying to build an replication and subscription beteween db in SQL 2000. The db holds our business system (Dynamics NAV, earlier Navision) and several of the tables include $, spaces and even : We can take some of this away when creating a new db or make scripts for some actions but I wonder if the mirroring in 2005 could handle this Thanks, Mikael Hi Listam, Mirroring will take care of it. Mirroring is at the database level. The whole database is mirriord and does not allow you to filter individual tables. Unlike transactional replication, the mirror data will not be accessible, unless you create a database snapshot on the mirror database on the mirror instance. The database snapshots with mirroring should ...Show All

• sun919 Convert hexadecimal value to real data type

  Hi , I want to convert hexadecimal to numeric data type. Using directly Cast or Convert function is not working. Please suggest an alternative how to retrieve the numeric value of binary data . Thanks in advance Regards Srinivas Govada Srinivas, Please show us what does not work for you. The following is fine: declare @n numeric(10,2) set @n = 1.23 select cast(@n as varbinary(20)) -- returns 0x0A0200017B000000 select cast(0x0A0200017B000000 as numeric(10,2)) If you are trying to convert binary representations of [float] values to [float], you can use this code: declare @b binary(8) set @b = 0xC094D954FB549F95 declare @s bit declare @e smallint declare @m float set @s = case when substr ...Show All

• cbpd86 Database master key

  Hi For encytion in database, the following statement is correct I found it in msdn book. The database master key is not mandatory if you want to encrypt data. If you don't have a database master key, you will need to specify password encryption. You can use the following to create the certificate: create certificate <cert_name> encryption by password = '<your_password>' with subject = '<subject>' For symmetric keys, asymmetric keys, and certificates, you can always optionally specify and use a password for encryption instead of using the encryption hierarchy. Please check BOL for the proper syntax. They should be similar to " ENCRYPTION BY PASSWORD = '<password>' ". This is very usef ...Show All

• Haugst3d Replication Snapshot Incorrect Parameter

  After using the wizard to create a very simple snapshot. I keep receiving this message: Replication-Replication Snapshot Subsystem: agent D700PT106-gdalcd_10-test-3 failed. The parameter is incorrect. The step failed. Anybody have any idea what this means. I need to ask you a few questions before I can troubleshoot this further: 1) Is this SQL2000 or SQL2005 2) Is this a clustered system 3) Are there anything interesting in the SQLServerAgent log -Raymond ...Show All

• Satyajit All dates between the start and end date

  Table Data/Structure Name StartDate EndDate HrsWorked Rick 01/01/2006 08/01/2006 8 Mike 02/01/2006 11/01/2006 8 How can I create a report that will display all dates between the StartDate and the EndDate and in the column underneath the date, put "8 hrs worked." Jan0106 Jan0206 Jan0306 Jan0406...... 8 8 8 8 0 0 0 0......Till Mike's start date in February Thanks -Rob You're talking about generating data thats not contained in but can be derived from the dataset. Your best bet is to do this in your query and return a row for every day and person. This looks like a jo ...Show All

• elGuille How do i display a checkbox on a report?

  Hi, I've been trying to display a checkbox on a report using unicode text eg. (U+2616) (Arial Unicode MS). I get the error: BC30037: Character is not valid. I have read somewhere about using html formatting to display it, how could this be done Is there any thing else i could do Thanks, Sam. I got my solution finally. Stupid me that didn't know I can open up the expression editor to choose functions from, and didn't know I can right-click the field to open up expression editor. Thanks anyway. I"m interested in seeing your solution. Can you post as reply to this thread I'll bet a lot of us report designers could use this little tidbit. thanks, tex ...Show All