Answer Questions

• Macromullet Tabs missing from Reporting Servers home page

  When I am trying http://localhost/Reports/Pages/Folder.aspx I am not seeing the all too familier "Contents" and "Properties" tabs along with deployed reports. Once in a while, I see that, but most of the time it is missing. Reporting Services got installed correctly though. It shows a very blank-ish Home page. Thanks. I can not open the link. Not at least right now. Would you please let me know if you have any clue Most likely, you are browsing with a user that has not been granted permissions. By default, only local admins are able to see anything. Thanks Brian. I am a local admin in my workstation where I am trying to open the home page ...Show All

• rivi Porting Access Database

  I am still pursuing my studies. I have been recently assigned a project for building Database Application for my college's library. And there was no better option to implement it with VB.NET 2.0 & SQL Server 2005. VB.NET 2005 & SQL Server Express 2005 are the resources at my disposal. The problem is that the college already has a Library Management System in place, built in VB6.0 with Access. I have been asked to pepare the application from scratch. But the database obviously cannot be left out. Now, can anyone suggest me an efficient way to port the Access database to SQL Server express. Also, the databse has been desinged poorly & is not properly normalized. Can I port it to SQL Server Express with some slight modifications t ...Show All

• infomax INFORMIX ODBC PROTOCOL

  hi all, Happy new year! is anybody here familiar with the different informix ODBC protocol such as Sesoctcp and onsoctcp and the rest of the protocols I think my SSIS design is affected by this protocols i'm having problems with the unicode and non unicode conversion. many many thanks Joey Do you have a unicode line uncommented in an Informix odbc.ini file hi Phil, thanks but i dont wanna to transform lots of columns it would be a waste of time and thats a bit painful i wish that can be done automatically. regards, joey   joeydj wrote: hi Phil, Using OLEDB i can have it saved using the UDL (universal data Locator, if i can still remember ) but it ...Show All

• SParker Tracking down Logins/sec

  Hi, I've have a SQL Server 2005 instance that has a Logins/sec value that is consistent at about 30. Logouts/sec sits close to zero. It seems to me that a value of 30/sec is quote high so I have been trying to track the connection initiations down. Also, since Logouts/sec is close to zero I would expect the actual number of connections on the server to grow at a fast rate (but I don't). I have tried to track down where the Logins are originating from with SQL profiler by filtering for Login and Logout Audit events. However, I do not see logins coming in at 30 per second and even if I did the client information doesn't seem to be getting captured. My intention is to find the machine that the majority connections are coming from and se ...Show All

• Steveinbeloit SQL Server Error 15404

  I am trying to learn replication and using Agent jobs while attached to my corporate domain. Trying to use my personal domain account to run jobs or replication, I keep getting: SQL Server Error 15404, Could not obtain information about Windows NT group\user 'MyName\MyDomain', error code 0x5 [SQLSTATE 42000] (ConnIsLoginSysAdmin) What might be preventing SQL Server from getting my account information from the domain Group ploicy Thanks in advance, Richard It's a bad practice using your personal account for services Better make a new domain account (service-specific), say: "SQLSERVICE" that has a password that never expires Else every time you change your password, your accou ...Show All

• Jay-P problem with custom conflict resolution

  Hi all, I am doing a work were i have to syncronize data between a Publiser (PC, SQL SERVER 2005), and a subscriber (Pocket PC, SQL CE MOBILE). I studied lots of articles and i managed to put the syncronization to work, the problem is in conflict resolution! The subscriber can’t insert or delet, only update!! For exmple: I have a table that contais the quantity of a product X, for example 100 units, this goes to Pocket, but later arrive move 100 units that are increased in the PC, so we get 200 in the PC, (but 100 in Pocket), no problem if i syncronize now (Pocket will have 200 too) , but if remove in Pocket for example 50 units, i've changed the same column in both Publisher and Subscriber database, if i syncronize now, ...Show All

• SUMEET_1876 Looking for Meta Data Coalition website

  The SQL Server Books Online makes several references to the Meta Data Coalition (MDC) in regards to the Open Information Model (OIM). The link in the MSDN documentation is http://www.mdcinfo.com . This link does not work and that URL now belongs to some other organization. Is the MDC still in existence By the way, I did some Googling and found the PDF of the original OIM proposal from MDC dated 1999. ...Show All

• PeterFreeb XML, XQuery, and my descent into madness...

  Hi, I've been trying to use XML Schemas and XQuery with SQL 2005 but with no luck. I'm trying to store a vCard in xml and query it. I've got some XML, I've got an XML Schema - it all validates. I put the schema into the database fine. I create a table with an XML column and tell it to use the schema. Aok so far. I add the namespace to root node of the XML and insert it into the XML columns. It goes in without errors. I run an XQuery on the column asking for the first child of the root - it throws an error telling me "There is no element FN" so, after much banging of my head on the table... I create another XML column but I don't assosciate with the schema. I fill it with the same XML but I don't add the namespace attribute to the ...Show All

• h3mp toDatetime.

  Hi everyone! I'am working with DATE fields inside SQL Server. When I try to save values from my web form, look what's happen: First tried, I did not use the ' '... 1. 1/1/1901 Error = [1] - Incorrect syntax near '/'. Second, I use the ' '... 2. '1/1/1901' Error = Server Error in '/WebAppCAE' Application. -------------------------------------------------------------------------------- String was not recognized as a valid DateTime. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: String was not recognized as a valid DateT ...Show All

• Vijay Guru Prasadh Help with script and variables

  Hi If I try to run the code below I get the following errors Server: Msg 156, Level 15, State 1, Line 36 Incorrect syntax near the keyword 'view'. Server: Msg 170, Level 15, State 1, Line 51 Line 51: Incorrect syntax near '@month1' . I am not sure why it does not like the keyword view also I am trying to use the variables in the column name of the create table but again it does not like this. -- declare all variables! DECLARE @startdate datetime, @enddate datetime, @enddate1 datetime, @month1 char, @month2 char, @month3 char -- declare the cursor DECLARE call_data CURSOR FOR SELECT dbo.removetime(DATEADD(month, -3, getdate())) as startdate, dbo.removetime( ...Show All

• henri805 Native Exception Error - 0xc0000005 on SQL Server Mobile 2005 Repair

  Hi, I got this access violation as I do a Repair on an SQL Server 2005 mobile edition database. The exception occurs only on a specific type of corruption of my database. The Exception information : ExceptionCode: 0xc0000005 ExceptionAddress: 0x01669a48 Reading: 0x00000014 The log of the corruption is the following : Source : Storage Card\mydb.sdf Destination : \Storage Card\sql8000.tmp Repairing - verMajor: 3, verMinor: 0, verBuild: 5206, verPoint: 0 Time - 2007-17-01 16:31:55.000 Bad Checksum - idPage: 1031, tyPage: 3, iPage: 2 Bad Checksum - idPage: 3828, tyPage: 4, iPage: 1 Bad metadata - m_blobOwner Block page not found - pwszTable: __SysObjects, idPage: 205635 Block page not found - pwszTable: __SysObjects, i ...Show All

• Christian Hecht Processing SSAS2005 from DTS

  Hi, I have a requirement to process SSAS2005 cubes from DTS. Anyone know how to do this or does anyone have any recommendations I've done a search on this forum and came up with teh following which was no help at all unfortunately: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=198374&SiteID=1 -Jamie I just tried the download and it appears to work OK. Give the download another try, maybe there were some transient network issues. Momo: ascmd was added to the SQL Server samples in SP1, you can download the latest samples from here http://www.microsoft.com/downloads/details.aspx FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en Unfortunately I am pretty sure AS 2000 does not supp ...Show All

• Vijay Guru Prasadh x64 Opteron running SQL Server 2005 in 32-bit?

  Hi, I installed SQL Server 2005 Ent. on an x64 AMD Hammer server running Windows 2003 Server Std. x64 ed. When I open SQL Server configuration Manager and view advanced properties of the SQL Server (MSSQLSERVER) then the 'Running under 64 bit OS'-parameter is set to 'No'. When I try to change this to 'Yes' and press OK the system changes the parameter back to 'No' Does this mean that my x64 server is running SQL2k5 server in 32-bit mode Can anyone explain Thank you very much. - Jacob  Hi, I got the same here on DELL PE285. but my machine seems running very slowly. Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1184224&SiteID=1&mode=1 for ...Show All

• Rui Mauricio No Debugging and logging when a single script task is executed

  Hi, I cannot execute a script task in the VBA code window. I cannot debug or log if I run a single script task from the right click Execute Task . Every time I have to run the entire package in order to be able to debug. What am I missing appreciate a help. Gulden Thank You.. I guess it is the only way.. try disabling all the other tasks and/or containers except the script task. then, execute the package. Gulden wrote: Thank You.. I guess it is the only way.. If memory serves correctly, yes, it IS the only way. We hope this will change in the future. It certainly SHOULD be changed! -Jamie ...Show All

• Tom Frey SQLXML Bulkload

  I'm attempting to setup bulk loads of xml files we receive in batches from remote locations (POS transaction info) I've got an XML document obtained from an XSLT transform that I'm trying to use the bulk load object on, along with an .xsd I created with the help of xsd.exe. Everything appears to run fine, but nothing ever gets loaded into the DB. I'd appreciate if someone could take a look at my schema/tables as I must be missing something, or haven't quite understood the XSD documentation. Here's the database tables: CREATE TABLE [dbo].[tblJournalHeader] ( [StoreLocationID] [varchar] (255) , [ReportSequenceNumber] [int] NOT NULL , [PrimaryReportPeriod] [int] NOT NULL , [SecondaryReportPeriod] [int] NOT NULL , [BeginDateTime] [da ...Show All