The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

4
votes
2answers
145 views

Is it necessary to install SQL05 Express w/VS2008 if I have SQL Server 2005

Is it necessary to install SQL Server 2005 Express with Visual Studio 2005/2008 if I already have SQL Server 2005 installed? I'm wondering if SQL Server Express adds any integration that SQL Server ...
4
votes
1answer
3k views

Windows 7 Credential manager and accessing SQL Server from outside of the domain

My SQL Server is set to use Windows authentication. If I am connected to the domain directly from my Windows 7 Ultimate x64 machine, SQL Management Studio (SSMS) will let me authenticate with Windows ...
2
votes
1answer
889 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
0
votes
1answer
26 views

Does anyone know of a program that can search database objects (i.e. StoredProcedures) for keywords?

Is there a tool that would look through a group of stored procedures for source code keywords? A client has a lot of business logic coded into their database and I need to find where it is using ...
0
votes
6answers
2k views

sqlserver 2008 or 2005 express cannot install on Windows 7 home?

When installing 2008 it says it requires .NET 3.5 and 2005 fails : what can I do ?
0
votes
1answer
2k views

Getting account lock status in MS SQL Server

I want to unlock an account in MS SQL Server. Before unlocking I have to check whether the account is locked or not - I only want to unlock if the account is locked. Are there any SQL queries or ...
2
votes
1answer
98 views

Do data sources travel with a particular mail merge document?

Do data sources that you set up (particularly to SQL Server) travel with a mail merge document? In other words, if I set up data sources in a mail merge document on my machine and then save and send ...
2
votes
0answers
295 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
2answers
3k views

Problem creating ODBC connection to SQL Server 2008 with Vista

Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured ...
3
votes
3answers
4k views

Archive Outlook mail items into SQL Server

I am looking (and so far not finding any) for a solution to archive e-mail items from my Outlook into SQL Server. My PST is beginning to get really really big, and I'd love to extract my older e-mail ...
0
votes
2answers
115 views

SQL Server on Linux

For a particular project that is coming up, I am trying to expand my knowledge of Linux, so I am going to set up a Linux system at home. Rather than dual booting, I am thinking about putting SQL ...
2
votes
3answers
1k views

Why does MS SQL Server Management Studio almost freeze up my computer while it restores?

Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
1
vote
3answers
2k views

How to connect to a SQL server through a public IIS server

I have two computers on my LAN. One with IIS and a public IP, the other with SQL Server and a LAN IP. How I can access to the SQL server through the IIS server from a computer connected to the ...
0
votes
1answer
677 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...
3
votes
2answers
2k views

How can I start using MS-SQL Server ( express )

I have just installed Microsoft SQL Express from here: http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx I need it because an example of some code I have uses it. How do I start using ...
3
votes
1answer
2k views

I can't “unmaximize” my window

I've got a windows app (I don't think it matters which one, but in case you're wondering, it's SQL Server Profiler) that I can't put back into "windowed" mode. I can maximize or minimize it, either ...
3
votes
3answers
1k views

Is my system compromised? I got message about ntoskrnl.exe

I am not sure this question belongs her or not but let me try. When I get to office this morning One of my colligues had a problem with his laptop and told me he had trouble restarting it and when he ...
23
votes
10answers
92k views

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
0
votes
1answer
302 views

How to find sql server instance?

I have sql server 2000 and 2005 installed on my machine. Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [2005] (this some instance i don't remember now) So is ...
0
votes
1answer
217 views

SQL Server 2000 Client won't connect

One day instead of connecting to the database my SQL Server Management gave me the following error: "Data Source name not found & no default driver found" Note it had been working for several ...
1
vote
3answers
2k views

Connecting from Mac OS X 10.6 to MS SQLServer

I develop iPhone Apps so my set up is a Mac running Snow Leopard (10.6). However the databases that the App connects to all run SQL Server (2005 or 2008). I would like a native (free?) solution to ...
3
votes
3answers
3k views

Creating a named pipe on Windows

I want to write a large dataset from a SQL Server 2005 database using BCP (bulk copy program). Ideally I'd like to do the following: bcp MyDatabase..MyTable OUT STDOUT -c -t, |gzip -c ...
0
votes
1answer
66 views

Password format not liked by installer

I'm installing Chargeback and I get to the database-related information page (step 5 on page 17 of the users guide). Using a Windows account (it is an administrator of the server and I am logged on ...
2
votes
3answers
894 views

WIndows XP file path in Windows Vista?

I am looking for a SQL Server file I am supposed to delete, only the instructions I found for this are for Windows XP and my OS is Windows Vista. And as ridiculous as this is, I cannot find this file ...
1
vote
2answers
2k views

Start an SQL Server instance without SQL Server Management Studio

I took my SQL Server 2008 offline because I was trying to do something... Now I can't log in to it using SQL Server Management Studio anymore. "The server was not found or was not accessible." I'm not ...
1
vote
4answers
4k views

Copy a SQL Server 2008 database verbatim

I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another. How do I do that?
3
votes
2answers
12k views

How do I give myself admin rights to a sql server instance, having forgotten the sa password?

I have lost all passwords for a SQL Server instance, how do I give myself admin access again?
0
votes
2answers
2k views

Registry entry for Microsoft SQL Server

How can I check from the registry which Microsoft SQL Server(2000,2005 or 2008) is installed in my computer?
0
votes
4answers
11k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
1
vote
1answer
3k views

Problem with logging into SQL Server Management Studio

I can log into SQL Server Management Studio with a SQL Server Authentication login and password, but when trying to log in with Windows Authentication I get this error: "Cannot generate SSPI context. ...
1
vote
1answer
337 views

Opening offline version of Microsoft Books Online in browser

I often use the MSDN website for language reference. In order to make navigation faster, I downloaded the offline version of SQL Server 2005 Books Online from here: ...
0
votes
3answers
256 views

How can I know about the local SQL Server on my system ( windows 7 )

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.
1
vote
1answer
654 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
1
vote
2answers
1k views

Can I install Sql Server 2008 on my windows home server

I would like to do more with my Windows Home server than file sharing and backups. Has anyone tried installing SQL Server 2008 (any version, but I'm using Professional) on a Windows Home Server?
6
votes
5answers
21k views

Rule “Restart computer” failed when installing SQL Server 2008

When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message: Rule "Restart computer" failed. A computer restart is required. You must ...
1
vote
1answer
197 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
1
vote
1answer
635 views

What do these Microsoft Updates do, and why can't they configure correctly?

MB: Biostar M7NCG 400 CPU: AMD Athlon XP 2200+ 1.8GHz RAM: 2.5GB (I don't know the speed, but does it really matter?) Display: NVidia GeForce 4 TI 4200, with hardware support for ...
2
votes
1answer
455 views

How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?

I'd like to make it Ctrl-Shift-F to match Visual Studio. I realize to do that I need to remove that binding from the Query->Save to File item. But, I can't even add ANY shortcut. When I pull up the ...
1
vote
1answer
2k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
0
votes
1answer
2k views

How to backup Windows 7 Live Photo Gallery?

How do I backup Windows Live Photo Gallery? I've been running on Windows 7 RC and I want to upgrade to the full Windows 7 release. I've been managing my photos with Live Photo Gallery. I want to ...
4
votes
2answers
151 views

How do I connect to a SQL Server DB to run some queries?

I have a SQL Server DB but have no idea how to connect to it to run some queries. I naively assumed that I'd be able to open up a DB in a similar fashion to Microsoft Access, but can't seem to do ...
1
vote
3answers
491 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...
1
vote
2answers
2k views

SQL Server Linux admin tools

I would like to know if there is sql server tools for linux? eg. tools like sql server enterprise manager.
-1
votes
2answers
506 views

What does the term CXPACKET stand for?

Google does not appear to have a definition of the term.
1
vote
1answer
99 views

What registry entries does SQL 2005 rely on, and which information does it store in them?

I am looking for an exhaustive list of registry entries that are only used by SQL Server 2005, and documentation on what they are used for.
1
vote
2answers
372 views

Trouble logging into SQL Server

Getting error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Restarted the service, server, and all the computers in between. I suspect it's not ...
10
votes
3answers
22k views

Which ports to open for Microsoft SQL Server?

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
0
votes
4answers
18k views

Run as administrator needed for IE8 workaround but user is in Administrators group

I'm running IE8 on Windows 7 and logging in under a company domain account (not the machine domain). The domain account is assigned to the machine's administrators group. As a workaround for the issue ...
2
votes
1answer
2k views

Can I delete files in the 'C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG' folder?

This is on my development machine, running Windows XP, and I don't run any production db's on it.
3
votes
1answer
2k views

SQL Server Connectivity Test

Many times people around me fail to connect to SQL Server from other Non-Microsoft Applications. Assuming that there is no SQL Server Client installed, what are the different ways we can ...