The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
12 views

Microsoft SQL: dealing with invalidated databases

I created a Microsoft SQL Server database that has now changed location. (The details are probably unimportant, but for the curious, I originally created it in a folder on an external drive mapped to ...
2
votes
1answer
1k views

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 ...
0
votes
1answer
64 views

Powershell and SQL Script Execution in selected schemas

Any one please help me on this one also..I have got many schemas under one database. And in that database I have some SQL Scripts to be executed. My issue is that I should be able to execute those sql ...
2
votes
1answer
58 views

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 ...
0
votes
1answer
411 views

Word 2010: Mail merge to a table in a schema other than dbo

I'm trying to perform a mail merge to a SQL Server 2005 view. I created the same view twice, once without specifying the schema (ie. DBO), and once with specifying the schema. In SQL Server ...
2
votes
1answer
434 views

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 ...
1
vote
0answers
14 views

Installing SQL Server 2005 with advanced services on Windows Server 2008 Enterprise [duplicate]

Possible Duplicate: Is it possible to install MS sql 2005 on Windows 7? I want to install SQL Server 2005 with advanced services (Reports support and Bussiness intelligence tools) on ...
1
vote
1answer
95 views

Visual j# asks for SQL 2005, but I already have SQL Server 2008 installed

I recently installed Visual Studio 2010 full pack (including SQL Server 2008). After that, I installed Visual j# Express 2005 in order to work on a project. The problem is: When I try to open a new ...
0
votes
0answers
48 views

Cannot find default local server after formatting the computer

I cannot find the default local server after formatting the PC. I installed Microsoft SQL server 2005 x64, but I cannot find the default local server. I can't find SQL server configuration manager in ...
0
votes
0answers
544 views

How to install and use Quality Center 10.0?

Please let me know where can I download HP Quality Center 10.0. I want to install HP Quality Center 10.0 on my local laptop and want to have hands on practice on the tool. Please also let me know ...
1
vote
1answer
763 views

How to show a confirmation message when Windows shuts down?

I want a custom confirmation message when the user shuts down Windows, but there should be some points: When the user is trying to shut down, it should show the confirmation message. If the user ...
1
vote
1answer
763 views

How can I install SQL Server 2005 on Windows Server 2008 R2?

Is it possible to install SQL Server 2005 Developer SP3 on Windows Server 2008 R2? If so, is there anything special that needs to be done to get it to install properly?
3
votes
3answers
2k views

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 ...
0
votes
2answers
321 views

How to connect SQL Server across the Work Network?

SQL 2008: I am trying to access SQL Database which is running on Server / Test Computer which has Windows XP OS. My Computer and Test Computer both are connected in our Local Network. Still I am ...
3
votes
1answer
638 views

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 ...
0
votes
1answer
358 views

SQL server is disabled when trying to connect database to .net

Generating user instances in SQL Server 2005 is disabled when I am trying to connect my database to .net. I used sp_configure ' user instances enabled' to generate user instances. What should I do?
0
votes
0answers
789 views

Cant create table using Microsoft SQL Server Management Studio Express

When I try to add table do database I get window with this error: =================================== Nieokreślony błąd. //that means Unspecified Error (MS Visual Database Tools) ...
-1
votes
1answer
215 views

Enterprise Manager clone for SQL Server 2005 or later

Is there any project attempting to reproduce the functionality of Enterprise Manager for SQL Server 2005 and newer? I know Aqua Data Studio is sort-of-close. Are there any projects that understand ...
1
vote
3answers
273 views

Could not find file 'SqlAccess.dll'

When running CREATE ASSEMBLY MyAssembly FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll' an error is returned: Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL ...
2
votes
0answers
424 views

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 ...
0
votes
2answers
742 views

MSSQL Server Management Studio Express 2005 license limit error should not be displayed

I just tried restoring a 250MB database from a backup on my local machine, and got the following message: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore ...
0
votes
1answer
39 views

issue on MS SQL managament studio 2005..?

am having MS SQL 2005 developer edition. And when am trying to install it(MS SQL 2005) on my windows XP SP2 system- am not getting MS SQL management studio..?/ what will be the issue..??
2
votes
1answer
49 views

How can I write queries in Microsoft Access to do a scan for the database

How can I write in queries in Microsoft Access to do a scan for the database?
0
votes
1answer
142 views

SQL Server 2005 - backup during database changes

Is backing up live database that is being actively used safe and consistent ? I mean will the system take a snapshot of all tables when backup starts or does it save each table content as it was when ...
1
vote
0answers
58 views

Update Billing Email Addresses in Sage MAS90

I have been tasked with trying to find a method of updating about 500 customer email addresses in MAS90. I recently discovered that they had the ability to email invoices to their customers and ...
2
votes
3answers
1k views

Error while installing Visual studio 2005 in Windows 7 Ultimate

I have tried to installed Visual Studio 2008 and Sql Server 2005 on windows 7 & following is the result. SQL SERVER 2005 :- Installed correctly without any error, but when I opened Management ...
2
votes
1answer
12k views

How can I install SQL Server 2005 on Windows 2008 R2?

Is it possible to install SQL Server Express 2005 SP3 on Windows 2008 Server R2? If so, is there anything special that needs to be done to get it to install properly? I ran into some issues with the ...
0
votes
6answers
1k 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 ?
2
votes
2answers
5k views

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 ...
3
votes
2answers
1k 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 ...
2
votes
2answers
92 views

Problem in SQL Server 2005

I know how to create tables in SQL server 2005. However due to system problems I reinstalled SQL Server 2005. After that I select the option like this: Start > Programs > Microsoft SQL Server 2005 > ...
4
votes
1answer
696 views

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?
2
votes
1answer
492 views

Clean install of SQL Server Express 2005 and Vista x64 Home Preminum

The install for SQLSRVREXP 2005, for Vista x 64 its SQLEXPR_ADV.EXE downloaded from ...
1
vote
2answers
5k views

Where to download MS SQL Server 2005 Developer Edition?

Just got put in charge of a big web project. All I know is the web server is running MS SQL 2005, so I need something comparable to test locally. I figure developer edition is my best bet because it ...
3
votes
3answers
2k 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 ...
2
votes
4answers
1k views

Installing SQL Server Express 2008 on Windows Server 2008

Can I install SQL Server Express 2008 on a Windows Server 2008 or should I stick with the SQL Server Express 2005?
3
votes
1answer
1k views

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 ...
2
votes
2answers
2k views

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 ...
3
votes
3answers
24k views

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 ...
1
vote
5answers
7k views

I can't find SQL Server 2008 (or 2005) on my computer but it is installed

Can anyone tell me how I can find SQL Server on my computer? I downloaded MS Visual Web Developer 2010 Express. The MS Web Platform Installer 2.0 tells me that SQL Server is already installed on my ...
0
votes
2answers
300 views

SQL 2005 Install completly broken on laptop

My problems started when I set up an exploratory domain controller at home. During that process, I changed the name of my laptop, from 'erisia' to 'erisia-laptop', and this resulted in me losing my ...
3
votes
4answers
1k views

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 ...
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. ...
0
votes
2answers
2k views

How To edit some packages stored in msdb

im a newbie with sql-server 2005. i build some packages which import some flatfiles into tables, each file goes into his table. Now there is a change in the structure of one file. Now i am too ...
1
vote
1answer
1k views

Is there a new virus affecting boot sector?

This weekend I have been fighting a horrible scenario where TWO of my computers (XP with AVG) went into an endless Restart-loop. Both of them could not load Fail-safe mode. Both could not boot from ...
1
vote
1answer
196 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?
5
votes
4answers
812 views

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 ...
1
vote
4answers
91 views

SQL Server 2005 on laptop. Not sure if I can delete

I have SQL Server 2005 on this laptop. I probably got installed along with Visual Studio. The thing is, I don't use it and it's constantly running. Process Explorer reports that it has a virtual Size ...