Questions tagged [sql-server]
Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.
4,805
questions
0
votes
2
answers
11k
views
TCP/IP packet loss network testing (in context of PingPlotter)
My question may be pretty basic TCP/IP / router based, but I need to couch it in terms of a Winpcap application pingplotter that I have used.
One of the features I did use in my last place of work ...
0
votes
6
answers
3k
views
Hiding SQL Server 2005 system objects/schemas from Microsoft Query
End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering ...
0
votes
2
answers
929
views
How can I connect to a MS SQL instance?
Is there a way to browse the .DAT files or connect to a MS SQL Server instance?
2
votes
1
answer
14k
views
What permissions might be missing on error 229 from 'tables' node on SSMS object explorer
I have just added a login to test an ETL process on a database and I get the error described below when connect using the account I click on the 'Tables' tab on the object explorer on SSMS on a ...
0
votes
3
answers
4k
views
How do I resolve the error "The file exists" when restoring a cube backup?
I'm trying to restore a cube backup (a .abf file) using SQL Server Management Studio, but I'm getting the error message:
The following system error occurred: The file exists. . (Microsoft SQL ...
2
votes
6
answers
4k
views
SQL Server 2008: Encrypting and compressing backups: Suggestions?
Greetings!
Anyone using Red gate (www.red-gate.com) or another third party tool to do this?
We use SQL 2008 Web Edition.
Thanks!
2
votes
2
answers
5k
views
Sql Server email query results
I have a query that I would like to run against SQL Server on a regular schedule and have the results of the query emailed to a distribution list. I'm not looking for anything fancy, just plain text ...
1
vote
3
answers
3k
views
Which Collation should we use for a web application - SQL Server 2005
We'd like to use the equivalent to UTF-8, but Can't seem to find the appropriate option within SQL Server 2005. Any thoughts on which we should use?
0
votes
2
answers
92
views
Designing AD Domain for SQL Server in multiple third-party locations
I have an application that uses SQL Server where I plan on deploying four instances to four different third-party dedicated hosting providers. The databases will replicate between each other. So, does ...
1
vote
4
answers
23k
views
I can't find firewall on Windows Server 2003 Enterprise Edition
I Just want to open the 1433 port for SQL Server locally, please I dont know who config this server so when I try netsh firewall , prompt saids "the command not exits" by the way routing and nat are ...
1
vote
3
answers
2k
views
SQL Server 2005 Maintenance Plan Succeeds But Reports Failure
I'm having a problem with a maintenance plan in SQL Server 2005. It's a very basic maintenance plan - it has one 'Execute T-SQL Statement Task' which simply inserts a row into a table.
When I ...
1
vote
2
answers
282
views
SQL Server 2005 Disable Database Diagrams
I was wondering if there was a way to disable the use of the database diagrams in SQL Server. This is more of just an annoyance for me, because I never use them and I am constantly prompted to create ...
0
votes
2
answers
875
views
SQL Server Merge Replication merge agent gone missing
We've got a pair of SQL2000 servers that are syncing a couple of databases using merge replication. At some stage in the last few months, the merge agent for one of the databases disappeared. It's ...
3
votes
2
answers
600
views
How do you backup a database within SQL Server 2005 from the command line?
I need to create a scheduled task that will backup a database within a SQL Server 2005 instance.
Is there a command line argument that I can use to achieve this?
2
votes
2
answers
2k
views
How do I configure ASP.NET to use SQL Server 2008?
I recently installed Windows 7 on my computer, and just set up Visual Studio 2010 and SQL Server 2008. On my old installation, I used VS 2008 and SQL Server Express 2005. I have a simple ASP.NET ...
3
votes
2
answers
467
views
How do I connect to a SQL Server on an ISP using SQL Server Management Studio?
It's actually SQL Server Management Studio Express. Do I need the full version? How do I connect?
0
votes
5
answers
4k
views
SQL Server 2000 + ASP.NET: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I just migrated a development workstation
FROM: Windows XP Pro SP3 with IIS 6
TO: Vista Enterprise 64bit with IIS 7
Since the move, one of my pages that accesses an SQL Server 2000 database is ...
1
vote
1
answer
7k
views
Sql Server Reporting Services stops working after changing service Logon account
Using Sql Server 2008.
I am attempting to install Team Foundation Server as a dual server setup (due to one server being the DC.) Part of the installation requirements is that Sql Server Reporting ...
4
votes
7
answers
38k
views
Move stored procedures from one database to another in SQL Server
I'm using SQL Server 2008, and I would like to copy stored procedures from one database to another. How?
2
votes
2
answers
778
views
Problem running “Central Administration” website after windows update at Windows 2003 Server Standard Edition
I was have WSS 2.0 and then I upgraded to WSS 3.0 and the old instalation database was SQL 2000, now I have another SQL Server instance called:server_name\MICROSOFT##SSEE .
After upgrade every thing ...
2
votes
2
answers
4k
views
SQL Server Management Studio missing when I installed SQL Server 2005
For some reason SQL Server Management Studio is missing when I installed SQL Server 2005 Developers Edition. Any reason why or how can i get SQL Server Management Studio on my PC?
My operating system ...
3
votes
2
answers
355
views
Can I still use WMI to manage SQL Server 2005 and 2008?
I've seen some articles on how to use WMI to manage SQL2000 servers (after installing SQLWMI80.msi manually) but I've not seen anything about this for SQL2005 and SQL2008.
Has this been depreciated? ...
4
votes
2
answers
5k
views
Permissions required for an SQL Server account
We're trying to get SQL running under a domain account, however we're not sure what permissions will be required for the service to start.
At present it is just a standard user in the active ...
1
vote
2
answers
482
views
Deleting Security->Logins on SQL 2005 that are not mapped to a database user?
In my demoenvironment I juggle lots of SQL databases. Each database has lots of Users, which are linked to separate Security->Logins on the server.
Over time I keep ending up with many (like hundreds)...
2
votes
4
answers
2k
views
SQL Server Express 2008 Not Starting Automatically after Power Off
One of our clients has a Windows 2008 Hyper-V instance hosted by CrystalTech, and sometimes the parent Hyper-V server is restarted without the child VM's being shut down properly.
As a result, when ...
5
votes
4
answers
65k
views
How can I tell what license I have on an install of SQL server, or Windows Server?
Is there any easy way to find out what license(s) are associated with a running copy of SQl Server, or Windows Server 2008?
I have technet subscriptions, and an MSDN subscription, but sometimes I ...
0
votes
2
answers
483
views
VM Hosting Account and Buying SQL Server / License [duplicate]
Possible Duplicate:
Can you help me with my software licensing question?
Thinking about signing up for $100 Windows 2008 Virtual Machine Hosting Account
I am going to be running a Web Server (IIS)...
1
vote
2
answers
309
views
sql mail and ssrs
Is it possible to attach a report from SSRS as PDF and send using sql mail? the server is MSSQL 2000.
1
vote
5
answers
702
views
Microsoft SQL Server API
I have an idea for an application, but ideally it would rely on being able to write a sort of "sql rewriting" engine for MSSQL (much the same way that HTTP servers can have "URL Rewriting" modules) ...
7
votes
2
answers
36k
views
Changing database owner in SQL Server 2008; CLR issues depending on method used?
I attached a database and tried changing the owner to a valid login.
I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa".
The database properties showed that the new owner was '...
1
vote
2
answers
1k
views
How do I enable e-mail alerts in SQLServer?
I'm trying to enable e-mail alerts for an operator in SQL Server (2000).
When I try to test the e-mail, I get the following message:
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session ...
2
votes
3
answers
1k
views
How can I tell what user account is being used to perform an action (in context of SQL Server)?
For example, when installing SQL Server 2008, I had to pick an account for the database engine to run as.
When I went to attach a 2005 database file with SQL Server Management Studio, there was a ...
8
votes
6
answers
26k
views
Enable SQL Server to backup on remote machines/drives
I have a SQL Server (2000, 2005 and 2008) and I'd like to use SQL Agent (or even a simple backup database 'xxx' to disk = 'yyy'), to backup to remote drives.
I.e: i have a mapped drive in the SQL ...
2
votes
3
answers
848
views
Upgrading Sharepoint Database from SQL Server 2000 to 2005
We are preparing to upgrade our database server from SQL Server 2000 to 2005. I'm planning on doing an in-place upgrade to maintain accounts, privileges, etc., and I'm hoping it will be pretty ...
3
votes
3
answers
3k
views
Correct settings for tempdb to avoid significant changes in free space
Every two to three days we are getting the following SCOM error:
The database tempdb in SQL instance
MSSQLSERVER on computer
sqlserver has
experienced a significant change in
free space
...
1
vote
1
answer
2k
views
SQLVDI error - attempt to release mutex not owned by caller
I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
1
vote
6
answers
9k
views
SQL Server Instancing: Should I use multiple instances or databases?
I have a reasonable server connected to a SAN which will be running SQL servers for multiples of the same application. There are no security issues with one application being able to read anothers ...
1
vote
2
answers
515
views
SQL Server Performance counters
I have a SQL Server 2005 instance that is experiencing some slow times. This link shows the perfmon details. Since I don't analyze this type of data daily, I was wondering if there a some real ...
2
votes
2
answers
210
views
SQL Server 2000 Encryption Certificates
I am trying to import a new certificate because our old one is going to expire very soon.
The certificate is ok and valid and works for IIS.
Unfortunately SQL Server won't startup with Encryption ...
1
vote
4
answers
812
views
Encrypting a column in SQL Server 2000 database
I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt ...
1
vote
4
answers
1k
views
SQL Server cluster failover leaves databases "suspect"
I'm in the middle of server maintenence, I upgraded 1 node's bios and windows updates and now I'm attempting to failover our database cluster to the passive, updated node. It fails over fine, but two ...
4
votes
8
answers
4k
views
MS SQL Layout for best performance
We have purchased a new server to act as a MS SQL backend. I am curious to know what the best setup would be for it.
The server is a Dell R710 it has 6 hard drives 2x 74GB 15k and 4x 146GB 15k
...
1
vote
3
answers
448
views
Idera SQL Safe Freeware Edition: What's Your Verdict?
I'm considering using this tool to compress my backups. I'm looking to speed up the backup and restore process, more than to save disk space. Have you used it? If so:
How did it go? Any particularly ...
3
votes
2
answers
2k
views
Setting Up Login for ASP.NET Application on SQL Server 2008
I have 2 Windows 2008 Servers. One is a web server (IIS7). The other is a database server (SQL Server 2008). The instance of sql server 2008 is configured to use mixed mode authentication. Neither are ...
5
votes
2
answers
2k
views
SQL Server 2008 Trace Flag 4135
Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008.
There is a KB article that recommends ...
1
vote
3
answers
378
views
SQL Server 2008 free hosting? [closed]
I am not sure if this thing exists but... I know there's free code hosting for svn and svc, where each user can download the code from a central repository and update to it.
Me and a couple of ...
0
votes
6
answers
9k
views
Connecting remotely to an SQL server inside a LAN
I am using SQL server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.
The problems rises when I try ...
0
votes
2
answers
4k
views
How can I improve SQL server mirroring performance
(reposted from stackoverflow)
I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this ...
1
vote
3
answers
4k
views
OPENROWSET, binary files, varchars and varbinaries
I'm trying to upload a binary file into SQL Server, into a varbinary field. I've came up with this query to do it:
INSERT INTO Files(File, Name)
SELECT
"file.bin" AS Name
* FROM OPENROWSET(BULK ...
5
votes
2
answers
6k
views
Clustered indexes versus non-clustered indexes?
I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the ...