Questions tagged [sql-server-2008-r2]
The sql-server-2008-r2 tag has no usage guidance.
31
questions
0
votes
1
answer
1k
views
SQL Server 2012 repair/installation fails
We have a Windows 2012 R2 server and want to run MS SQL Server 2012.
It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
1
vote
2
answers
24k
views
Installing SQL Server 2008 R2 on Windows 10 64-bit
I am trying to install SQL Server 2008 R2 on a Windows 10 64-bit machine.
I get a message telling me that
This app might not be work correctly.
Microsoft Sql Server (2008 and 2008 R2) isn't ...
0
votes
0
answers
857
views
Why SQL Server 2008 Reporting Services keep crashing when connecting to remote database server instance?
Background
I successfully setting up a database for SQL Server Reporting Services in Windows Server 2008 R2 using Reporting Services Configuration Manager with "Create a new report server database" ...
0
votes
1
answer
2k
views
ODBC connection to Cisco UCCX
I followed this guide to successfully create an ODBC connection to UCCX, but using the 32bit driver. I need to use the 64bit driver and the GUI changed dramatically.
My 64 bit ODBC settings
Below is ...
1
vote
0
answers
58
views
Presenting relationship of rows in SQL Server
I have two tables named FORM and FORMACTION. The rows in FORM represent screens in a CRM system and FORMACTION represents which FORMs lead to which. e.g.
FORM
ID,NAME,LNAME
1,"CustomerD","Enter ...
2
votes
1
answer
384
views
Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See
My computer has the following Software involved.
Microsoft Windows 7
Microsoft SQL Server 2008 R2
Microsoft SQL Server Management Studio
Moreover, I have the following Drive partitions:
C: drive
...
0
votes
2
answers
19k
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 ...
1
vote
1
answer
494
views
Access SQL Server from remote location
I have remote access enabled in SQL Server at my work network, which is on my "server". In the office, I have my desktop machine which I can use SQL Server Management Studio to access - no problems. I ...
0
votes
1
answer
21
views
Include job in bak to be activated on restore
I have a database with stored procedures and a maintenance job that runs some of the stored procedures nightly.
When I take a backup of the database, is there any way that I can include the job in ...
3
votes
1
answer
456
views
Install sql server management studio API only
I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql ...
2
votes
1
answer
3k
views
The Login is from an untrusted domain - domain setup with computer level login
I have a SQL Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string.
The database resides on a 64-bit Windows Server 2003 machine. The ...
0
votes
2
answers
1k
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 ...
1
vote
0
answers
122
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 ...
23
votes
4
answers
16k
views
Floating or vertical results pane in SQL Server Management Studio
I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another.
Can this be achieved? Either by having the results pane ...
4
votes
3
answers
34k
views
Installing SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation)
When I Try to install SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation), a compatibility warning massage is displayed,
Tried Get help online option but it is says No solution found, but setup ...