Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
0
votes
1 answer

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is needed. I have removed the default instance (as i want…
mwillmott
  • 242
  • 2
  • 8
0
votes
1 answer

Unable to restore database using Microsoft SQL Server Management Studio Express

I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express. It gives following error message: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is…
meetpd
  • 115
  • 4
0
votes
2 answers

Removing SQL Server Express 2008 Instances

How can SQL Server 2005 Instances be manually removed (if uninstall does not clean them up)?
Danny
  • 121
  • 6
0
votes
1 answer

sql server installation problem

can sql server 2005 service pack 3 be installed in windows vista?
Pradeep kumar
  • 1
0
votes
4 answers

Reinstall Reporting Services 2005

We are having problems with our reporting services portion of SQL server 2005. Can someone provide some guidance for reinstalling reporting services?
Ronnie Overby
  • 681
  • 2
  • 12
  • 24
0
votes
2 answers

SQL Server backup

I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B Shut-off client…
zzz777
  • 101
  • 3
0
votes
1 answer

Replication Publication Configuration

When trying to configure a publication I get the below error. SQL Server could not configure 'MyServer' as a Distributor. ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch.…
user42937
  • 113
  • 6
0
votes
1 answer

Why does this login fail for user 'Servername\Guest'?

I install SQL Server 2005 EXPRESS edition on one computer, Computer Name = 'MyServe' and Database name='MyDB',take it as database server. it is configured as both Database and Windows Authentication Mode. with username=sa and password=adminaa. I…
Metassebia
  • 1
  • 1
0
votes
1 answer

How do I Trace SQL Server 2005 through restarts?

At my company I need to create a Trace on our SQL Server (for a workload file), that should run for several days. However, The Server is turned off every night, so the trace dies. How do I make a Trace that will continue automaticaly on the next…
Shany Tooper
  • 1
0
votes
1 answer

oracle sql developer and sql server

What should I input the connection name there? I have a database called Stack Overflow... I tried the hostname as localhost and it didn't work
EquinoX
  • 367
  • 3
  • 11
  • 27
0
votes
1 answer

SQL Server Express 2005 SP4 Issues

After applying sp4 to sql server express 2005 and subsequent reboot, the service pack still appears as a needed update in Microsoft Updater.
Halphonse
  • 1
0
votes
2 answers

monitoring the size of an SQL Server connection pool

We are trying to track down a performance issue. One theory we have is that we are running out of connections in the connection pool. Is there a way to monitor the size of a connection pool?
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
0
votes
1 answer

Speed up delete in a huge table with clustered index

I need to delete a large number of records from a huge monster non-partitioned table on a Microsoft SQL Server 2005 database. Table contains about 8.388.483.218 records, I need to delete 1.069.012.556 of them. Because of the lack of disk space for…
Danilo Brambilla
  • 1,031
  • 2
  • 15
  • 33
0
votes
1 answer

SQL Server 2005 inserting null when value hard coded

I have a stored proc that creates an entery in a table. INSERT INTO tbl_CaseDetails ( Case_Id , Client_Id , Client_HO_Id , Client_Case_Ref , Client_Cust_Ref , Access_Id …
Steven
  • 101
  • 1
0
votes
1 answer

Sql server 2005 and windows 7

I have the symptoms in this articles, but I have Windows 7 32 bit, and "Group Policy Management Console" dos not work install due to compatibility problem so I can't follow the tutorial. Can you help me running SQL server 2005…
Costa
  • 127
  • 1
  • 6
1 2 3
…
71 72