Can someone tell me why this doesn't work?
Using SQL Server 2019. SSMS v18.1. FieldQuote option does not seem to be recognised by SSMS as it remains black rather than changing to blue for keywords.
My data is as follows:-
12345, 124, "this…
Trying to connect my Db2 server to the newly installed SSMA (V9.2). I have MS OLEDB installed (v6) and can connect successfully with the client however I can't run a samply query in MS OLEDB. In both tools, I'm getting the following error message:…
Greetings. I have a very simple Azure SQL DB audit that works exactly as expected... then stops overnight for some reason.
So I can define my audit and confirm that it's set correctly:
Set-AzSqlServerAudit -ResourceGroupName "myRG"…
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
I'm trying to import data into my SQL Server using SQL Server Import and Export Wizard and I keep getting this error message:
TITLE: SQL Server Import and Export Wizard
Could not retrieve table list.
A network-related or…
I am trying to migrate the data from the same table for 15 companies in Odata Source using Foreach Loop Container (the number of companies may change). But, I have difficulties in making this process dynamic. I will appreciate if you can you share your…
We are planning to migrate all of our Windows Server 2012 R2 Standard to Server 2019 Standard. For this, we will have to migrate our SQL server 2016 (2 instances Running in windows cluster) to new Windows Server 2019 Standard server machines. We…
I recently noticed that replication monitor is not working properly. Whenever I try to launch it, the icon shows in the Taskbar of my indows but the application never actually open.
Anyone with similar issue, please advise
Is there a way to check whether my nonclustered indexes are rebuilt or not while I rebuild my clustered index.
I just cant rely on create date and modified date in sys.all_objects.
I am using create unique clustered index..with…
Good morning all,
We have MSSMS and our tables we have TimeStamp columns which are set as datetime.
How can we select entries based on a specific date apart from using the below?
WHERE TimeStamp < '2021-09-03 23:59:59.999' AND…
I have geography object which contains many LINESTRING
I want to give distance from this geography object
and to find the position on the geography
Declare @g1 geography =geography::STGeomFromText('LINESTRING(7.068419558716859…
I have a table as shown below. You can see some duplications. My question is how to eliminate the duplications. The same question was asked on https://learn.microsoft.com/en-us/answers/questions/1163799/how-to-eliminate-duplication. Now the…
I'm having a problem installing the reporting role
SCCM installed on server A
SQL and Report service install in Server B
But when I start configuring the role, it doesn't show me the name of my reporting role database
I read several articles…
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
hi , can replication be limited to just some tables on the db or must it be on the entire source db? and if the source has timestamps, will there be any problem for sql to keep them as is on the target/replicated db?
Change Tracking is activated on a Microsoft SQL Server 2012
To get the Commit Date of the changes we LEFT JOIN on table [sys].[dm_tran_commit_table]
FROM CHANGETABLE(CHANGES [Grf].[ChangementStatut], 55169) ct
LEFT OUTER JOIN…
For an Archival process we have swithced out a partition to a new table . but this table Totalpages used space is very high compare to the usedpages.
what could be the reason for alocated_memory space is too high ?