Viewing 15 posts - 76 through 90 (of 260 total)
Sorry, I hereby withdraw my entry. I used a bit operator, not the power function, and that does work with the testdata, but is not a valid general solution. The...
July 25, 2022 at 8:39 pm
What OS version is the remote SQL Server 2012 running on?
If the server is runningWindows Server 2012 or older, it may not have the cipher suite to support a TLS1.1...
July 21, 2022 at 8:34 pm
Yes, but do you have a copy of the database on a different server, and access the table in the remote copy from the view (using four-part identification and linked...
July 21, 2022 at 7:57 am
NO,
All the tables resides in same database.
Are you absolutely sure of that?
Because according to the documentation the columns referenced_server_name, referenced_schema_name and referenced_entity_name are only not-null if an object is...
July 20, 2022 at 3:26 pm
It does look strange. I notice that there are some implicit conversions involved - the parameter @p8 is converted/cast to nvarchar(4000) and the cid column is likewise implicitly converted/cast to...
July 20, 2022 at 12:59 pm
You stated nothing about equipment_id in your original post. How am I supposed to include logic for your equipment_ids when you tell us nothing about them?!
Easy now! 🙂
He did...
July 19, 2022 at 8:49 pm
I'm no expert on Powershell scripts by a long shot, but I think you should try to do an explicit cast to NVARCHAR(MAX) or XML on your insert command.
As I...
July 19, 2022 at 8:17 pm
(deleted)
July 19, 2022 at 8:02 pm
Should be a very basic query. Try
SELECT Object_Id, Schema_Name, Table_Name, SUM(Value1) AS Value1, MAX(Date1) AS Date1
FROM Table
GROUP BY Object_Id, Schema_Name, Table_Name
ORDER BY Object_Id, Schema_Name, Table_Name
July 19, 2022 at 6:33 pm
Okay, that did shed more light on the issue.
It seems the view and tableB reside in different databases. This is a problems, since the sys.xxx files do not span databases...
July 19, 2022 at 4:50 pm
I could see as attached.
Ahh, okay. I think you'll have to comment on that image, because there isn't much to see after you have redacted most of the information....
July 19, 2022 at 3:34 pm
Also, if you run this:
SELECT
o1.Name as ReferencingObject,
o1.type_desc AS ReferencingObjectType,
d.referenced_server_name,
...
July 19, 2022 at 2:51 pm
Stange! My tests don't show this behavior. What do you see in SSMS when you look at the dependencies? Do the view show as a reference from TableB?
July 19, 2022 at 2:14 pm
Please note that if the the view references a table through a synonym the direct reference from the table will not be there. Maybe this is your use case?
July 19, 2022 at 12:27 pm
Viewing 15 posts - 76 through 90 (of 260 total)