1
vote
0answers
61 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
0
votes
3answers
40 views

Copying SQL Server 2005 Databases

We currently have a single SQL server (2005, on a Windows server 2003 machine) with 3 DBs on it that I would like to just straight copy so that I can run some test on them for an upgrade. I don't ...
0
votes
1answer
125 views

Writing to a txt file by xp_cmdshell

I m trying to write query result to txt file. Here is my code: exec master..xp_cmdshell 'bcp "select * from Leasings" queryout "DHCPLog.txt" -c -t,-T MyServerIP' But the result is : And there ...
0
votes
1answer
43 views

SQL 2005 Server memory requirements and performance

What is the risk involved in running on 91% RAM usage on Windows Server 2003 32 SP2 and SQL Server 2005 in terms of SQL Server performance? Server has 3GB and mostly sits at around 80% mark with ...
0
votes
2answers
47 views

Is it possible to change a cluster that is dependent on a domain?

Recently we received (2) Poweredge 6850 and (2) PowerVault 220s from our managed server company. These two servers hosted SQL Server 2005 with our SQL database on it. The cluster was dependent on ...
0
votes
1answer
11 views

sql server installation problem

can sql server 2005 service pack 3 be installed in windows vista?
3
votes
1answer
82 views

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of ...
1
vote
2answers
294 views

SQL Server: Filegrowth options for Data Warehouse database?

I'm creating a database for data warehousing purposes. The database will grow about 10 000 - 100 000 rows in a week (this is a guess). I think that I'll have to go with database file autogrowth, what ...
2
votes
1answer
743 views

Cannot generate SSPI context from SQL Server Management Studio (2005)

Yesterday I went through some troubles to set up a DB on my local machine. I finally got that working, but now today I am getting an error when I try to connect to a remote machine. Cannot generate ...
2
votes
7answers
313 views

24/7 IT Support Cover [closed]

Hope this isn't off topic but do any of you provide 24/7 cover with a colleague and how much would you expect to be paid? Say once every 3 weeks or possibly every other week? 6K+ per year? Would be ...
1
vote
3answers
732 views

SQL Server Enterprise Edition: Use more than 4GB of RAM on a 32 bit Machine?

I would like to install SQL Server 2008 on a 32 bit machine. I have read that it is possible with the SQL Server Enterprise edition to increase the memory over the 4GB? Is this true? Any ...
0
votes
1answer
95 views

How do i archive newly added DB backups?

I'm using Windows Server 2003, Sql-Server 2005 and 7-zip for archiving. Each day maintenance plan adds all DBs to backup and i need to archive those but just those files. How do i create .bat or ...
1
vote
2answers
395 views

Impact Disabling “Update Root Certificates” Has On SQL Server

I was told that Disabling the Update Root Certificates option from the Windows Components section of Add/Remove Programs will cause SQL Server to stop working properly. It this correct, or is my ...
0
votes
1answer
44 views

sql server permissions

Hi How can I set permissions againt existing windows groups in sql server 2005
1
vote
2answers
467 views

Cannot generate SSPI context

I'm trying to connect between two SQL Servers to set up log-shipping. I'm getting the following error when connecting from the Publisher to the Subscriber: Cannot connect to DRBOX Additional ...
2
votes
2answers
738 views

User or role does not exist in this database

I am trying to add a new login in SQL Server 2005. I can go into the security properties for the database in SQL Management Studio, and I can select a domain user, but when I click OK to close out of ...
1
vote
1answer
477 views

SQL 2005 Active-Active configuration - Shared Quorum?

I am planning for this scenario: SQL 2005 with an Active/Active configuration (that is, 2 nodes, 2 instances, each node holds active one of the instances, each node is the other's backup) The SQL ...
3
votes
5answers
438 views

Executing SSIS package

I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business ...
2
votes
3answers
96 views

How to bring DB Engine Security together with Database Security MSSQL 2005 Express?

When we restore a backup created with the command below we get all the security settings on the database level but the users on the engine level are not created. osql -s myserver -E -Q " BACKUP ...
0
votes
2answers
1k views

Why does Windows Automatic Updates ignore SQL Server service Packs?

Why does Windows Automatic Updates ignore SQL Server service Packs? Windows Server 2003 Standard X64 Service Pack 2 No WSUS server in the picture just Automatic Updates enabled. Default install of ...
0
votes
4answers
370 views

Why some XP installs don’t automatically Start SQL2005 Service (Instance)

I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager. On 1 or 2 of these machines when you reboot, the SQL ...
2
votes
4answers
818 views

How to reserve system resources to specific SQL Server 2005 databases?

Is it possible to specify a min/max amount of system resources (Disk IO, Memory, CPU cycles/s) available to each database instance inside a SQL Server 2005 server? This would be the analogue of QoS ...