A major vendor of computer software, best known for the Windows and Office products. Microsoft also produces SQL Server, a widely used DBMS platform.
0
votes
1answer
17 views
How to create via sql and detect via ERRORLOG SQL Server 2008 Deadlocks
I am designing a monitoring program using HP Sitescope SIS.
The goal is detect deadlocks.
In doing so, I created a deadlock on an existing but nearly unused SQL Server 2008.
I used the following ...
2
votes
1answer
92 views
Selecting with varbinary(max) criteria (in the where clause)
Basic info
Database: SQL Server Express 2008 R2
Client: SQL Server Management Studio
Backround (skip if not interested):
A project I'm maintaining uses an ORM, which apparently stored my enum ...
1
vote
1answer
266 views
Exporting data from Microsoft Access table file subsets to plain text
I have a problem in exporting data from Microsoft Access. I have an Access file made of several rows and columns, like this:
Every row contains a subset of data, tha could be observed by clicking ...
1
vote
0answers
292 views
Missing 'Microsoft Office 12.0 Access Database Engine' in SSMS
I've got several users that need to import / export ACCDB Access files into out of SQL Server.
Unfortunately, I have been unable to get 'Microsoft Office 12.0 Access Database Engine' to show up as a ...
2
votes
2answers
492 views
SQL Server drop and create all users in every DB
I would like to drop and recreate every user in a database without having to manually do this for 500 users. I have this so far:
USE [Maintenance]
GO
IF EXISTS (SELECT * FROM ...
1
vote
1answer
453 views
Is there a backup operator role in Microsoft SQL Server 2008?
I have a Windows Server 2008 with Microsoft SQL Server 2008 and VERITAS NetBackup installed. Basically, this NetBackup requires a valid logon ID into the SQL Server that is powerful enough to do a ...
3
votes
1answer
63 views
Many to many unique combination
So I originally thought I was going to have a one to many relationship in a database with the following tables
ENTITY_JSON_MAP
ATTRIBUTE_JSON_MAP
Originally I was going to have an FK in ...
1
vote
0answers
62 views
Looking for a good 3rd party Microsoft SQL replication app! [closed]
We have an existing Microsoft 2008 SQL R2 database that we need to real time replicate to an identical off-site live web database. Transactional replication and merge replication will not be able to ...
1
vote
1answer
123 views
Database created in sqlcmd but missing in SQL Server Management Studio
I created a database named testbase in sqlcmd in SERVER\MSSQLSERVER. However, I cannot access SERVER\MSSQLSERVER.
I also could not find testbase inside the server connection using Microsoft SQL ...
1
vote
0answers
163 views
Connection to MS Access from Oracle over a DB Link
I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
1
vote
0answers
186 views
How do I auto-fill data in Microsoft Access 2003?
I am creating a Purchase Order Form at work using Microsoft Access 2003 so that it can be saved and archived in a database and reduce paper costs.
These are my current dilemmas:
I am unable to ...
1
vote
0answers
97 views
How do I use MDX scripting in SQL server 2005 Business Intelligence Development Studio to create the following Member?
I am using Microsoft SQL server 2005 Business Intelligence Development Studio to build a cube.
I need to calculate a member called INCREMENTAL OVERTIME. INCREMENTAL OVERTIME is based off of the ...
0
votes
3answers
80 views
Is it possible to check a date in SQL?
I'm trying to write a Microsoft SQL Server stored procedure which takes an account ID, and returns an authentication ticket and whether the ticket is expired.
Something like this:
SELECT ...
1
vote
2answers
444 views
is it possible to create a form in the intranet that can be stored in a database?
I am trying to create a form for my companies intraNet site. The idea is as follows:
An employee wants to make a purchase, so they will go to the appropriate page in the intraNet
They will fill out ...
0
votes
1answer
137 views
BI development in Microsoft BI
I need to learn how to create a dimensional modelling for an organisation that do not has a BI tool and BI model.
Where can I learn more about BI development that should be used in a company?
IT's ...
0
votes
0answers
34 views
What`s the simpler software and solution to create a multilingual database of translations? [closed]
Translating can be tedious an repetitive, and we are always learning because it is impossible to master totally a foreign language. I am learning english and I need mainly a bilingual database to ...
4
votes
1answer
581 views
Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required.
The application is a Java Swing heavy-weight GUI ...
2
votes
2answers
130 views
Anyone Know of Some Desktop Software that Searches an SQL server for a String
I have a database on a server that's running Microsoft SQL. I would like to find a tool that logs into that server, allows me to search to a string, and returns the tables and fields that contain that ...
2
votes
2answers
1k views
Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
We are just starting design for a new data warehouse and we're trying to design how our date and time dimensions will work. We need to be able to support multiple timezones (probably at least GMT, ...
2
votes
3answers
181 views
How to validate and upgrade my knowledge of SQL Server with MCSA
My story is that I am working now almost 10 years as an administrator, I deal with SQL Server and other IT stuff, most of my knowledge is self taught by reading books, dealings with problems and ...
0
votes
1answer
122 views
Connect to a Windows Authentication SQL server in SQL Server Authentication mode?
Is it possible to connect to a SQL server in SQL Server Authentication if the server has been installed with Windows Authentication?
1
vote
2answers
116 views
Execution Plans Query
I want to check the estimated number of rows of a query in MS SQL Server. I can right click on the query and select "display estimated execution plan". but I want to do the exact thing with a hard ...
3
votes
2answers
565 views
Why did Microsoft kill “English Query” on SQL Server?
Given the popularity of the natural language user interface Siri, which was acquired by Apple for $200 million, I've wondered if anyone knows why Microsoft killed "English Query" on SQL Server.
2
votes
1answer
710 views
Disable SQL Server Log Shipping to nonexistent destination
I am administering a SQL Server 2008 instance in a dev environment. At some point before I became an administrator, someone enabled log shipping from one of the databases on this dev instance to ...
3
votes
2answers
125 views
Microsoft SQL Server 2005 Encryption Options
I'm trying to explore some encryption options on Microsoft SQL Server 2005.
I've recently got around SQL Server 2008 and was able to enable Transparent Data Encryption (TDE). Now I'm trying to figure ...
6
votes
1answer
190 views
32-bit or 64-bit for development and deployment?
I'm creating a Windows desktop application and want to include a database. I've chosen SQL Server Compact 4 but when I download it there are two versions (32-bit and 64-bit). My development machine is ...
0
votes
2answers
94 views
SQL Server build
We are building a new server at work and I'm hoping to get ideas of how we should build it out for optimum performance and back-up capability. We have 6 drives and we need to have an OS (Windows ...
3
votes
1answer
128 views
In which form Microsoft SQL password should be given when creating a user?
I am creating a Microsoft SQL server user with the guidance of this MSDN article and giving the system the following commands:
CREATE LOGIN MyName WITH PASSWORD = 'MyPass';
USE My$DatabaseName;
...
6
votes
1answer
348 views
Mirroring problems after removing domain
I successfully created a mirror with certificates between two servers. One of those servers was a domain controller. After removing the domain the mirror was interrupted.After hours of searching i ...
6
votes
4answers
11k views
Can I see Historical Queries run on a SQL Server database?
Someone was running a query on our SQL Server database remotely and their system crashed.
They have no backup of that query and want to see what was run on the server.
Is it possible to find this ...
3
votes
2answers
538 views
Why did my UPDATE statement not complete?
Good morning. Running SQL 2008; Mgmt Studio 2008. I am working with a MS SQL job that we have created for our MS CRM 4.0 implementation. For anyone familiar with CRM, this job purges the ...
0
votes
1answer
880 views
Minimum user rights for connecting MS Sql database remotedly
I have followed this tutorial for getting connected to a Microsoft SQL Server. I connect with ping functionality of Glassfish Server and thus I have to give some user rights to be able to even ping ...
5
votes
1answer
308 views
The use of NOT logic in relation to indexes
According to MSFT's book on database development Exam 70-433: Microsoft SQL Server 2008 Database Development:
Neither leading wildcard characters not NOT logic allow the query optimizer to use ...
2
votes
1answer
334 views
Changing SQL Server 2000 usernames
We're running a SQL Server 2000 instance with users tied to Windows accounts. Many of the usernames have spaces in them and that is causing us some problems now. We would like to be able to rename ...
3
votes
1answer
786 views
Make SqlClient default to ARITHABORT ON
First things first: I'm using MS SQL Server 2008 with a database at compatibility level 80, and connecting to it with .Net's System.Data.SqlClient.SqlConnection.
For performance reasons I've created ...
7
votes
4answers
5k views
Feature comparison: Oracle Database and Microsoft SQL Server
Many companies have a heavy influence on market and technologies around them, and you often compare the products before you choose, e. g. I liked Oracle APEX, its flexibility and features, and we're ...
