Viewing 15 posts - 1 through 15 (of 444 total)
Tried TRUNCATE - no errors. Tried DELETE - 0 rows affected.
But I probably found the reason, this is likely to be a cloned database, that was created with DBCC CLONEDATABASE....
June 7, 2021 at 10:31 pm
Ran it now. Did not help. Also tried DBCC checkdb. Did not help either. In an output message it displayed There are 0 rows in 0 pages for object <table_name>...
June 2, 2021 at 6:28 pm
All tables are in dbo schema. None of tables that I've checked so far with select count(*) have records.
June 2, 2021 at 4:49 pm
Thanks both Brian and Scott, but unfortunately nothing worked in my case.
@Brian: This query returns empty result set:
SELECT spid
FROM master..sysprocesses
WHERE spid > 50 AND...
May 18, 2021 at 1:20 pm
No. And frankly, I never worked with it. Can you please give more details of how I can use it?
Thanks
February 26, 2021 at 2:17 pm
Thanks all for replies.
Jonathan, your solution works. The only downside is that it creates blockings. But this is what was expected.
February 25, 2021 at 5:13 pm
Thanks Mike!
This is exactly what I wanted.
December 18, 2020 at 5:11 pm
And yes, each new row should accumulate all the previous one plus the current one.
Thanks
December 18, 2020 at 3:25 pm
Here is DDL:
create table table1
(
col_to_order int identity(1,1),
column1 int,
column2 varchar(max)
)
go
insert into table1
(column1)
values
(123),
(71),
(1844),
(191)
go
December 18, 2020 at 3:23 pm
No, I don't have Visual Studio. And I am looking for SQL solution.
November 11, 2020 at 7:23 pm
Apparently it's XPATH. It looks like this:
SELECT ActivityLogXml.Activity.query('Comments').value('.', 'varchar(max)')
FROM @ActivityLogXml.nodes('/Activity') AS ActivityLogXml(Activity)
And the part ActivityLogXml.Activity.query is interpreted by sys.sql_expression_dependencies as db.schema.object
November 11, 2020 at 4:46 pm
I tried SQL Server Logs which is under Management folder, it does not have this info. Where I can find connection logs?
Thanks
November 3, 2020 at 5:55 pm
Thank you Grant, and all, for your advises.
What I also heard is that we need to collect a database workload from production and apply it on our testing environment to...
October 27, 2020 at 2:00 pm
They are views? But I specified o.type_desc = 'SQL_TABLE_VALUED_FUNCTION' in Where clause.
October 23, 2020 at 5:31 pm
This is not from production. This is from one lower env. to another lower env. (like dev, test, qa, like that)
October 22, 2020 at 12:25 pm
Viewing 15 posts - 1 through 15 (of 444 total)