Tagged Questions

1
vote
0answers
299 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
503 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
483 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
98 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 ...
2
votes
2answers
131 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 ...
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 ...
0
votes
1answer
123 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
569 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.
3
votes
2answers
128 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 ...
2
votes
1answer
721 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 ...
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, ...
6
votes
1answer
352 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 ...
0
votes
1answer
891 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 ...
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 ...
5
votes
1answer
312 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 ...
3
votes
1answer
796 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 ...