I changed the machine name yesterday (from Machine1 to Server1). I'd delete the SQL server registration in Enterprise Manager and register again with the new server name - Server1. Everything run correctly. But when I open the Profiler, create a new trace, I use (local) when "Connect to SQL...more >>

Hi, I want to identify, when the values are modified/updated on the particular row in a table, i am not using triggers in this table. Please advise me, any options in SQL Profiler Trace to find out this. rgds, Soura...more >>

Experts, I have a standard SQL 2000 installed onto a Windows 2003 Server on which I am a local administrator. An IIS server by way of ASP.NET uses this SQL database server as it's back-end. Someone told me there is a way in SQL to see who is using the database via the ASP>NET front-end on...more >>

How does one figure out, I mean compare the results after some changes have been done to the SQL Server, I mean the method in which the comparision is done, lets say I have a query I ran it it gave me the results in 40 seconds , I ran it again this time it took 30 seconds, then I again ran it it...more >>

How do I set/specify which table to store in which file group? Let's say I have 3 data file (1 primary and 2 secondary). I want system table to stored in primary data file, mostly used for reading tables stored in secondary data file 1, and transactional tables stored in secondary data file 2....more >>

Hi We are in the process of putting in a new SQL Server box. Initially running 2000, then probably 2005 quite soon. Thought it would be good to see what hardware you run, and if you like it! Our box will be doing heavy nightly importing of data then cube processing (to be accessed v...more >>

Hello, Using SS2005, is there a way to copy both the headers and the data when you run a query and paste the results in Excel? -- Thanks in advance, Steven ...more >>

And I am getting errors in the log indicating that Lock resource cannot be obtained. Why does SQL Server not decide to escalate the lock amd release some memory and cause other apps to throw the error. There are a lot of fine level key/row level locks consuming the memory. Do I have to j...more >>

Hello, I have an existing table with the following fields: tbl_users: this table has all the data userd_id(primary key) user_first_name user_last_name and the second table: tbl_notes: this table may or may not have a matching record with tbl_users user_id(primary key) user_notes user_...more >>

hi can anyone help, i have a database maintenance plan which is set to run hourly at the moment it overwrites the current database but i want to append it with a current_timestamp, here is the T-SQL i am using BACKUP DATABASE [company name] TO DISK = N'E:\Hourly Backup\Company\Company backup-...more >>

Hello, I am trying to find a way to write a program to do the following: Receive an image via email, retrieve that image and put it into a database. Could you please give me an advice where to start or point me into the right direction? Is there an ASP component somewhere that would do the...more >>

Hi , I am having a problem here... SQL Server is unable to log "error"s in the EventViewer though it is able to write the "Information" messages. The server is able to write to the SQL ErrorLog. Can someone give the reason why this is happening?? Thanq. ...more >>

Hi I'm working with SQL 2000, how can I find login name L1 is the owner of which objects() in which dbs?in other word, when I want to delete a login name in login list an error appears with the context of "you can n't delete it because it's owns some objects in some DBs". any help wou...more >>

Hi I am working with SQL 2000 and I have a resotred database with these users in branch of its users : DB1 user login ---- -------- dbo X L1 L1 L2 L2 but in other databases I have the following list: DB2 user login ---- -------- dbo sa X X L1 L1 L2 L2 I ...more >>