Tagged Questions
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 ...
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 ...
3
votes
2answers
564 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.
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
1answer
879 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 ...
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
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 ...
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 ...
