My  table created like this.

CREATE TABLE objects3(id  int  NULL, name varchar(1000)  NULL)
INSERT objects3 (id, name)
    SELECT object_id, encryptbypassphrase('Det är gurkor i...

The database is restored from Production database to the testing server.Is it possible to get information  from where it is calling.

Broker is disabled in the  database which is mentioned in error.but in other 2 database the service broker option is enabled.

Can this query be used to delete the queue.

            
August 14, 2020 at 10:18 am
            
#3780445

            
            
                                                
        

Using Sql trace i was able to get the Username but not the Query origin.

I used this Query.

Select * from Table_1

As i said earlier "In the license terms under the ‘Scope of License’ there mentioned “You may not publish the software for others to copy”."

I need to use SQL server 2008 because it' the latest SQL server which is supported in XP, there are many customers present who still uses the Windows XP operating...

ChrisM@Work (9/8/2014)

---

IT researcher (9/8/2014)

---

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the...

patrickmcginnis59 10839 (9/8/2014)

---

It really sounds like he tried this, but in the destination...

How can i import data without one...

GilaMonster (6/12/2014)

---

IT researcher (6/12/2014)

---

The SQL server instance is used by employees in office. So it will be running only during office timings. So we keep the server OFF during...

GilaMonster (6/12/2014)

---

The SQL server instance is used by employees in office....

Now i again took the report and found PAGEIOLATCH_SH is still at the top and have value of wait_time_ms 11067000.

The sql server starts everyday at 8:30 AM and stops around...

SQL server restarts every night. Does these values reset on restart?