All Questions
Tagged with ssms sql-server-2005
15
questions
2
votes
1
answer
764
views
Linking SQL Server tables to a PostgreSQL Server
I have a SQL Server 2005 instance and also a PostgreSQL 9.3 running on the same network, I would like to know if its possible to somehow create or have 'views' on a database within the PostgreSQL ...
11
votes
1
answer
9k
views
What is this upside-down silver key icon
I inherited a SQL Server 2005 3rd party server and database to look into to be able to generate reports and dashboards on.
On one table, I found a new icon: a blue-silver upside-down key, alongside my ...
1
vote
3
answers
2k
views
SSMS 2014 working with SQL Server 2005 instances
Is there any major complication that one could run into while using the latest (developer) version of SSMS with older SQL Server 2005 instances?
Any way one could affect the data by using this ...
1
vote
1
answer
85
views
Linked server in SQL Server 2005 using NT authentication impersonation
I am trying to Link a server using an NT authentication as the impersonated connection, but this connection will be static to a specific user instead of passing the currently logged-in user's ...
3
votes
2
answers
24k
views
How to make SQL Server Management Studio use latest version of SQL Server?
I'm upgrading my dev machine from Windows 7 to 8. While installing earlier versions of Visual Studio it installed SQL Server 2005. I then went to this site and downloaded and installed SQL Server ...
3
votes
1
answer
6k
views
How to disable SSMS table designer timeout?
How do I disable the Table Designer timeout in SQL Server Management Studio?
Background
This KB Article seems to indicate that if you stop overriding the Designer timeout:
To resolve this ...
2
votes
4
answers
4k
views
SQl Server Password Change after installation
I have installed SQL Server 2005, but at the time of installation I forgot to change my password. Now I can access my database only in Windows authentication mode, and I want to access the database in ...
5
votes
2
answers
378
views
Does Restore "From database" restore from the most recent backup of the database or the actual live database?
In SSMS 2005, I want to use the GUI to copy a database by restoring in to a new database. I was using the "From database" radio button for the source, but then the databases in the list disappeared ...
4
votes
1
answer
280
views
Odd SQL Server Studio error, but not on SQL Server Express?
I'm running a query that I got today from a previous question, and I just noticed an error that only happens when I run this query ON the server (RDC + MS Studio -- not express) vs on my machine which ...
0
votes
1
answer
61
views
Start Windows Service If Replication Fails
Setup:
We have SQL Server Management Studio 2005 SP3 on all of our Servers.
We have 1 Main Server, and 1 Secondary Server that has the database from the Main Server being replicated on it. (If it ...
2
votes
1
answer
1k
views
SQL Server Database Keeps Semi-Detaching Itself
Forgive me if I am not using all the proper terms but I have databases that will detach themselves from SQL Server. In SQL Server Management Studio the plus sign will be missing next to the database, ...
2
votes
1
answer
242
views
Enable SSMS in SQL Server 2005 Developer Edition
We just had an upgrade of all our computers here, and on one of them we loaded our licensed copy of Visual Studio 2008 and SQL Server 2005 Developer edition. I then loaded the service packs (4 for SS)...
2
votes
2
answers
959
views
Why is query using Clustered Index when it shouldn't?
Let us presume I have a table named Category in a SQL Server 2005 database. Category has category_id (bigint, identity) as its primary key and name (nvarchar(50)). There is obviously a clustered ...
5
votes
2
answers
4k
views
SQL Server query result transfer time over VPN (WAN)
I have a mysterious phenomenon on one remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 MBit/...
12
votes
6
answers
1k
views
Did anybody use sqlcmd mode in practice? [closed]
SQLServer 2005 introduced something called SQLCMD Mode msdn link.
At first glance this mode adds variable subsitution from command line batch files, and some escaping to OS commands.
Is this ...