I have a table where i do not control the input, but i will like to delete records there is older then a some data/time and i have tryed to make this Tsql to delete record older then 7 days, but it do not work well when the day of month is lower then 7 !!! anyone like to help a newbie ;-) ...more >>

hi, I assign an employee (John) to be a Database Owner of a database called HR. Why when he create a database object (table, view, or sp), the owner column shows John not DBO I thought when System Admin or Database Owner creates a object, the owner should be DBO, am I wrong or missing s...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hi people. Very new to this so not even sure if this is the right NG! We have started running our business system off an SQL Server. As such we are writing some views to help us, these are attached in Excel, Access etc. Anyway one is for orders. We need to group by week. In Access (where I...more >>

Hi, I need password user "sa" after default installation. Password is not empty. I am install MS SQL 2000 with Windows Authentication. =20 Thanks.=20 =20 Ond=F8ej Krebs CZ...more >>

Thanks to everyone on the earlier post. The issue there was the default path created by the restore wizard. In any case, the restoration completed and all seems well except backups, Integrity checks and optimization jobs fail. Other jobs created to update tables run correctly with the same use...more >>

Hi, I have a problem in SQL 2000. I have an db application where user can insert (by mistake) char type instead of an integer or numeric values. I created the following trigger in SQL 2000: CREATE TRIGGER trgEBL ON dbo.B FOR INSERT, UPDATE AS declare @value char(255) select @value =...more >>

I've got SQL 2000 Developer edition installed on Windows XP Pro. I'm trying to create a new instance. It seems to install fine but it always returns an error saying it could not connect. I've noticed when I read the log file that the password it used to connect is blank, even though I set o...more >>

My Sql server msdb database demaged. I did not backuped it before. I copy the msdbdata.mdf and msdblog.ldf from other SQL database. But not working. How can I fix it Thank ...more >>

I was tring to get the performance stats like CPU time per transaction, IO per transaction, etc. I tried SQL Profiler, but the event "SQL Transaction" tracks all transaction begin/commit/rollback and doesn't capture the resource used by the transaction. Is there any other ways of tracing the p...more >>

Hello, Is there any website/URL for SQL Server ,where in i can work from my home and contribute towards the open source projects? Please suggest! Cheers, Shyam...more >>

Hi, I am upsizing a complex Access database that is the back end to a web application to SQL 2000. It has taken quite a while to get it running in SQL Server - having to correct many queries to views, create stored procedures and correct relationships on fields of different sizes that access ...more >>

BlankI've developed database based applications for 30 years, but I'm brand new to Microsoft's version of databases. I have completed one business application in Access 2002/VBA and now I want to learn SQL/2000. I've read, in depth, the introduction to my old SQL Server Developer's guide, and ...more >>