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.

Filter by
Sorted by
Tagged with
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 ...
polyglot's user avatar
  • 103
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 ...
Ed Leighton-Dick's user avatar
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?
user avatar
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 ...
ConcernedOfTunbridgeWells's user avatar
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 ...
Ant's user avatar
  • 111
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!
Jonesome Reinstate Monica's user avatar
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 ...
user avatar
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?
dubRun's user avatar
  • 1,061
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 ...
McGovernTheory's user avatar
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 ...
Jonathan Escobedo's user avatar
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 ...
Gavin's user avatar
  • 111
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 ...
Ross Goddard's user avatar
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 ...
Dan F's user avatar
  • 143
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?
Josiah's user avatar
  • 269
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 ...
edobry's user avatar
  • 23
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?
Robert Harvey's user avatar
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 ...
Rick's user avatar
  • 103
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 ...
Chris Marisic's user avatar
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?
ala's user avatar
  • 185
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 ...
user avatar
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 ...
Etienne's user avatar
  • 273
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? ...
Guy's user avatar
  • 2,678
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 ...
user avatar
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)...
Frode Lillerud's user avatar
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 ...
Adam Brand's user avatar
  • 6,157
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 ...
EJB's user avatar
  • 1,319
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)...
Tyndall's user avatar
  • 591
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.
KellCOMnet's user avatar
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) ...
Nippysaurus's user avatar
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 '...
Triynko's user avatar
  • 3,428
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 ...
BIBD's user avatar
  • 1,876
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 ...
Triynko's user avatar
  • 3,428
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 ...
Martin Marconcini's user avatar
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 ...
Donald Gower's user avatar
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 ...
Alex Angas's user avatar
  • 2,047
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 ...
Chris W's user avatar
  • 2,670
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 ...
Spence's user avatar
  • 680
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 ...
Dwight T's user avatar
  • 209
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 ...
GordyII's user avatar
  • 151
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 ...
TGnat's user avatar
  • 121
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 ...
Aaron Jensen's user avatar
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 ...
ITGuy24's user avatar
  • 1,576
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 ...
David Wimbush's user avatar
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 ...
Ronnie Overby's user avatar
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 ...
lnediger's user avatar
  • 211
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 ...
user avatar
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 ...
user avatar
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 ...
Edoode's user avatar
  • 183
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 ...
Pablo Fernandez's user avatar
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 ...
RateControl's user avatar
  • 1,207

1
88 89
90
91 92
97