My fact table has a "Date" column that I have used as a foreign key to the Time Dimension table I used SSAS to create for me in the datasource. However when I deploy the cube and browse it, adding the time dimension attributes or any of its hierarchies do not filter anything on the measures. Its like there is a disconnect between the tim...
Is there a way to connect to a remote sql server using management studio with windows credentials other than the current login credentials? Right now i remote desktop into the sql server machine and login with the windows credentials that I want to connect with. Thanks. ...
I have a VB.NET windows application that when I debug it, it opens the connection. At that point I can see there are two processes created by going to the Activity Monitor in SQL Server Management Studio. I execute my query and then immediately close the connection. However, when I do that the processes do not go away. For the life of m...
In mysql, you can use mysqldump --xml to dump to XML. How do you dump a SQL Server database? Preferably to XML. ...
How can i query data from a table in Ms Access in my SQL server 2005 stored procedure ? ...
Can we furthur Normalize this Sql Table Structue is Primary key is ID,Date,NAme,Type ID Date Name Type Value ----------------------------------------------------- 1 08/15/2010 Rating A+ 10 1 08/15/2010 Rating A- 10 1 08/15/2010 ...
I am running SQL Server and I have a stored procedure. I want do a select statement with a WHERE IN clause. I don't know how long the list will be so right now I have tried something as follows SELECT * FROM table1 WHERE id IN (@idList) in this solution @idList is a varChar(max). but this doesn't work. I heard about passing in table v...
I had installed SQL Server 2008 and received a error now after about 7 months that the evaluation period has expired; without any previous notifications. I searched online and found that I needed to make a change in the registry and reinstall SQL Server 2008. I am trying to do upgrade install and getting the error: Rule "SQL Server A...
I have a Access Data Project that connects to an SQL server database. Recently I modified the structure of the database from the SQL server. Now whenever I try to open one of the tables, I get the following error. Microsoft Office Access can't find the object 'SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_l...
i have a simple mysql database. it has 3 tables. here is the create statement for them: CREATE DATABASE `qcvalues` /*!40100 DEFAULT CHARACTER SET latin1 */ CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` varchar(50) DEFAULT NULL, `reporttime` varchar(50) DEFAULT NULL, ...
I need help in TFS2010/SQLServer/MOSS2010 extranet deployment. I need a good guide. To setup everything like on the image below. thx. http://i.imgur.com/H1mAC.png ...
Hello, I have a view in SQL server that translates from one schema version to another. Currently, the view looks like this: SELECT newValue AS oldValue FROM dbo.MyTable The trouble is that, in the new schema, newValue is not nullable, so we set it to -1 to denote empty fields, but in the old schema, it was nullable. How can I do s...
I'm trying to develop a Crystal Report that passes the user executing the report as a parameter to the report query. I'm using Business Objects Enterprise, executing the reports through InfoView which I would assume uses the Crystal "Special Fields" Current CE User Name, I just can't figure out how to link that to the query. Am I think...
I did a succesful migration from MySql to Sql Server using the migration tool. Unfortunately for some reason it labels the tables database.DBO.tablename instead of just database.tablename I have never used Sql Server so perhaps this is just the way they name their tables. When I do: SELECT TOP 1000 [rid] ,[filename] ,[qc...
i have about 10 scientists writing to a mysql database i have migrated to sql server and now i have to deal with OWNERS does it matter which owner i choose? when i do automate migration frmo mysql to sql server it assigns DBO. is that OK? should i continue to use that? so now i have to do: SELECT TOP 1000 [rid] ,[filename] ...
OK so I've been tasked with upgrading an application which involves updating schema in a sql server 2005. Now I've been told their dr environment has a mirrored database. I've read the msdn article on mirroring but am unclear how it impacts my upgrade. Do I: a) want to stop the mirroring (someone mentioned a wizard, but I'm not sure h...
I have a question, but let me first say that this is being performed on a database which I inherited and I am currently trying to improve the design on. Also the reason for the syntax is the fact that there are a lot of tables that the datatypes have been 'tweaked' by tech support people (/facepalm) causing lots of issues. IF NOT EXISTS...
Is there support in SQL Server for loading/reading/transferring/importing/fetching/inserting XML, directly from a web-server, into a table? Pretend i want to fetch XML from a web-server, such as: exchange rates published by the Bank of Canada a web-site's current sitemap an rss feed SQL Server 2005 (and newer) has native support fo...
After performing an insert/update/delete, is it necessary to query the database to check if the action was performed correctly? Edit: I accepted an answer and would like to use it to convince management. However, the management insists that there is a possibility that an insert/update/delete request could be corrupted in transmission ...
Getting this error "This server version is not supported.Only Up To Microsoft SQL server 2005 are supported" after I create a data connection in Visual Studio 2008 SP1 and SQL server 2008 R2. Any ideas would be great. No other version of SQL server Installed. The error occurs after I select server, then database. Just as I click OK I ...