Server Configuration

Debugging SQL Server 2005 Transact SQL
I have an urgent requirement to debug Transact-SQL in SQL Server 2005 and I have a couple of questions. 1. Are there any *free* programs that will allow me to debug (step through line-by-line, look at cursor results, variables, etc). 2. If the answer is 'no' and Visual Studio is the least expensive alternative, wh... 17 Jun 2010 17:54

list tree database structure
Hello, i am trouble trying to do a SELECT . i have one table : persons (person_id, person_child,distance) WHERE distance is the number of generation between the person_id andpersonn_child_id. here is ans example of data : (1,1,0) --> himselsf (2,1,1) --> the child if person 1 (3,2,1) --> the child of pe... 16 Jun 2010 08:52

single user mode
Hi, I need to be able to establish an exclusive connection to the database and do a restore to it. Nobody, can be connected to that database prior to the restore. Also, I need to be able to schedule it to run on a daily basis. I tried putting that db in a single user mode and then do the restored in a transacti... 15 Jun 2010 17:40

Local Service, Local System or Network Service?
Hello, I am hosting a web site on IIS 7.5 in a Windows 2008 server. This web site requires an SQL Database so I configured the SQL Server to allow remote connections. What service should I use the the SQL Server? Local Service, Local System or Network Service? Thank You, Miguel ... 15 Jun 2010 17:40

db backups and time outs
Users are complaining that they are getting experiencing time outs to a MS SQL 2005 database. There is no explaination on the network, however lots of speculation that the time outs are happening during the full nightly backups. Is it possible that backups can cause the users to time out? ... 15 Jun 2010 09:49

SQL Server 2008 R2/Remote BLOB Storage/SharePoint 2010
We're looking into implementing SharePoint 2010 with a SQL Server 2008 R2 backend. We were also interested in using the RBS addon to get our files out of the database. We were hoping to place these files on a file server seperate from the SQL Server. In reading the docs, I have found where it says "To run RBS o... 14 Jun 2010 12:54

Database Queries with database views, that base on many databa
I use 32-bit SQL Server. But I will try 64-bit SQL Server. Thank you for the hint. I thought: The count of tables per SELECT statement is only limited by available resources. (I found this under http://msdn.microsoft.com/en-us/library/ms143432.aspx) What I am trying to achieve? The user of an application s... 24 Jun 2010 17:30

SQL Server don't use all memory
Hi, I use SS 2005 on W2003 EE 6GB with /PAE /3GB I set: max mem 2147483647 MB awe is checked SS is using only 100MB about from task manager : 5 GB is used the sum of all wotking set for all process is about 500MB any clue ? Thanks in advance ... 13 Jun 2010 14:57

Execute job from osql
Hi, I am a beginer in SQL Server I try to execute a job (maintenance plan) from osql I generated the script in a file (backup.sql) EXEC msdb.dbo.sp_attach_schedule @job_id=N'1a1e9373-eabf-480d-9b21-ad94025cd230',@schedule_id=21 GO osql -E -i backup.sql C:\Temp>osql -E -i backup.sql 1> 2> 1> and ... 12 Jun 2010 11:34

Array in MSSQL
hello guys, can someone show me how to create an array variable in an MSSQL database. Thank u. Francis ... 16 Jun 2010 04:32