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

IIS + PHP Data Objects + MS SQL?

We're migrating an LAOP server to Win 2k8 IIS7 MSSQL and PHP (WIMP?) at work, and I'm using the opportunity to clean up the PHP. Currently it doesn't use PDO, and I'd like to rewrite the PHP to use that instead. Challenge is, I don't know much…
jldugger
  • 14,342
  • 20
  • 77
  • 129
0
votes
1 answer

SQL Server Agent 2005 job runs but provides no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though). The job steps are: 1) Delete all rows from table; 2) Use For each loop…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
2 answers

SQL 2005 Log Shipping - Was working, now isnt!

I had log shipping working between two SQL 2005 server fine. I suspect that a job was added to the source server which backed up the transaction log to disk (nothing to do with the existing log shipping job). As I understand it, if you do this then…
BIDeveloper
  • 187
  • 10
0
votes
4 answers

What is the best way to backup the schema of a sql server 2005 express database?

I want to backup the schema of a sql server 2005 database from the command line. Whats the best way to do this? Update I ended up buying SQL Compare 8.1 from Red Gate Software. It works just as well as Change Director and is 1500 dollars cheaper.
Justin Tanner
  • 151
  • 1
  • 3
  • 7
0
votes
2 answers

SQL Server 2005 Agent running SSIS job can't find file path

Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table. The problem I'm having is getting the SSA to read the file path, the relevant…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
1 answer

Sql Server security Issue

how to add Sql server user for specific database with backup and restore permission only ??
MZT
0
votes
2 answers

SQL Server 2005 and SQL Server Express on the same machine?

Can we have both version installed on the same computer?
jason
  • 43
  • 1
  • 1
  • 5
0
votes
1 answer

How to determine server address in ms sql

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; trying to connect ms sql to vb.net, but I don't know how to determine server address, initial catalog and the user ID Please help
user28233
  • 125
  • 1
  • 3
  • 12
0
votes
2 answers

how to configure ms sql server 2005

I have just downloaded SQL Server 2005 express edition from here: To be used as a database for a vb.net program. But I'm confused in using sql server. I do not know where to start from here: http://screencast.com/t/ZTdiMDU5 Do I have to create the…
user28233
  • 125
  • 1
  • 3
  • 12
0
votes
1 answer

in MSSQL Server 2005 Dev Edition, I faced index corruption

When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted. Please advice me, here below is DBCC logs: DBCC results for 'itopup_dev'. Service Broker Msg…
grabtasker
  • 11
  • 3
0
votes
3 answers

SQL Server Managment Studio 2005 to an Express database

I just installed SQL Server Standard Edition with the Management Studio. I'm able to connect to my SQL server instance but I can't connect to a SQL Server Express instance on a remote computer. Is the Management Studio Standard able to connect to…
Julien Poulin
  • 135
  • 3
  • 7
0
votes
3 answers

How to script sql server 2005 database with data?

I use sql server 2005 as my database for my web application.... I generated scripts of the database by, Database->Right Click->Tasks->Generate Scripts I can script all my Tables,Stored Procedures,User Defined functions,Views,Users...... I have no…
ACP
  • 149
  • 1
  • 5
  • 12
0
votes
1 answer

Can I run a pull DTS package on SQL 2000 to copy data from SQL 2005 (compatibility level 90) to SQL 2000?

Can we still run our DTS package on SQL 2000 to pull data from a SQL 2005 database with compatibility level set to "SQL Server 2005 (90)" ??
Rick
  • 45
  • 3
  • 7
0
votes
1 answer

SSIS Foreach loop (SQL Server 2005) adding loop variable causes failure

I'm trying to use SSIS to traverse a directory of Excel files and put them into a table in SQL Server. I seem to have a basic choice - either I get the same spreadsheet dumped in the table 10 times or I get an error message. I'm using the…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
2 answers

Import database: SQL Server 2005 Express to SQL Server 2008 Enterprise

I have two servers 1 x SQL Server 2005 Express and 1 x SQL Server 2008 Enterprise How can I move/import my database from SQL Server 2005 Express to SQL Server 2008 Enterprise? (BACKUP SQL SERVER 2005 and RESTORE to SQL Server 2008, would that work?)
001
  • 491
  • 1
  • 11
  • 21
1 2 3
…
71 72