Super User
Super User

Questions tagged [sql-server-2005]

48 questions
10
votes
1 answer

Is there a way to play a sound when a query is finished executing

I was wondering if there was a way to play a sound after a query has finished executing in SQL server 2005?
user29908
7
votes
3 answers

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 c:\temp\dataset.csv.gz However BCP just writes this to a literal…
PP.
  • 2,885
5
votes
4 answers

SQL Server 2005 Management Studio is Slower than Molasses!

SQL Server Management Studio 2005 is so slow that I often want to use something command-line just so I can move on with my life and quit waiting for the stupid GUI to load. Have you ever run an update command and have the entire window lock up on…
Josh Stodola
  • 927
5
votes
2 answers

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 it? Which port does it open by default? All I have…
OscarRyz
  • 4,141
4
votes
3 answers

Microsoft SQL Server 2005 Express Edition SP4 wasn't installed

I lost track of my account when my question was moved to superuser. I wasn't able to install Microsoft SQL Server 2005 Express Edition SP4 through automatic update so I downloaded the update from here and tried manual install, which was also failed…
user754334
  • 63
4
votes
1 answer

Purging Expired SQL Server Backups

I have set up a SQL Server Agent job to execute a backup every night at 3am. The job appends the backup to an existing backup file, and sets the expiry of the backup to expire in 7 days time. It's been running for several weeks, but the backup file…
BG100
  • 205
4
votes
2 answers

SQL Server 2005, Huge LDF file

I have a database running on SQL Server 2005. The database is 20GB and the LDF file is 35GB ! I am now running low on disk space and want to shrink the log file. How can I do this and how can I stop this happening again ?
user33373
3
votes
4 answers

Is it possible to install Microsoft SQL Server 2005 on Windows 7?

I've tried several attempts to install MS SQL 2005 standard on Windows 7 Ultimate 32bit but wasn't able to. I've turn on all the IIS6 comptiable features. I'm not sure what I'm doing wrong but is it possible to install MS SQL 2005 on Windows 7? If…
Jack
  • 253
3
votes
4 answers

Windows Updates - Does Not Install, how can I remove it

Everytime I shutdown my Windows XP, it comes up with the following screen which says Turn Off with Installing Updates (Of course, it also gives me an option as follows, "Click here to turn off without installing updates.") When I do a normal…
Kanini
  • 1,092
3
votes
1 answer

Unspecified Error in Sql Server Management Studio

I just started getting an error window with "Unspecified Error" in MS Sql Server Management Studio 2005. I get this when trying to Create a New Table in a DB or Right Click > Design on an existing table. I am able to open up a new connection and…
Yaakov Ellis
  • 400
2
votes
2 answers

Can not access SQLServer database

I'm trying to convert an Access database to use a SQLServer backend. I've upsized the database and everything works on the server, but I'm unable to access it remotely. I'm running SQLServer Express 2005 on Windows Server 2003. The server is not…
user24803
  • 21
2
votes
1 answer

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL 2008 Express, but we are not upgrading the Client…
Jim
  • 338
2
votes
1 answer

What are the risks for logging across databases via a trigger?

I've searched for this online and had mixed or unclear responses. On SQL Server 2005, we currently log certain table changes via triggers using the inserted/deleted tables. Currently, our log tables exists in the same database as the primary…
archangel76
  • 121
2
votes
1 answer

Fill in Excel template with data from SQL sever

Every month I have to fill in an Excel template with data from some database, that is I have to fill in about 100 cells. I wrote SQL queries and I don't know is there any way that I could get that data into the Excel template other than copy/paste?…
paunic
  • 21
2
votes
0 answers

SQL Server 2005 Express won't uninstall

I'm trying to uninstall SQL Server 2005 Express from my machine. I think it got installed along with VS 2008, but I've never used it and now just want it gone. I go through Add/Remove to uninstall and I get this: I check Workstation Components…
Darryl
  • 255
1
2 3 4