The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
289 views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
0
votes
1answer
131 views

How Do I Suppress SQL Server “Informational” Messages?

I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for ...
0
votes
1answer
517 views

Problem with remote connection to my sql server 2008 R2

I wanted to use my PC as SQL Server and connect to it from my notebook but I can't connect to it via public IP adress. Later i will need to create connection string to my c# application but for now ...
2
votes
0answers
275 views

Why is my Access 2010 ADP not filtering its SQL statements when connected to MSSQL 2008 R2?

I use MSSQL MS for most administrative tasks on SQL Server 2008 R2 databases, but I find using Access (via an ADP, not linked tables) to view and edit raw table data to be much more efficient. (This ...
2
votes
0answers
132 views

Jira does not wait SQL Server to start

I am using Jira 3.1 for task tracking. It works over SQL Server 2008 R2. Recently I tried to use Jira as a service rather than running it from a command line. I have installed the service and put ...
1
vote
0answers
77 views

SQL Server Continues to Swap RAM After Using a Virtual Machine

I have a dev computer running Windows Server 2008 R2 Enterprise and SQL Server 2008 R2 Enterprise, with 8GB of RAM. As I write code and use the database, SQL Server will use more-and-more RAM (which ...
0
votes
0answers
15 views

How to query mssql db from bash on subsystem for unix

I have a script that is used to query a database and use the result set for further processing. This is a shell script that runs on bash. But the bash used is the one shipped in subsystem for Unix for ...
0
votes
0answers
24 views

SQL Server 2008R2 Developer's Edition Error while Installing

I had Sql Server 2008R2 Developer's Edition Installed on my machine, Two Named instances, Default Instance was Sql Server Express. and there was another named Instance Evaluation Enterprise Edition. ...
0
votes
0answers
67 views

SQL Server 2008 R2 crashes

I am using SQL Server 2008 R2 with Windows XP Professional with SP3 on my PC for development. I've noticed that during the last 6 months the SQL Server crashes and is corrupted again and again. What ...