Translating Queries - Hi, I know this is a crazy question, and I haven't been able to find the answer yet, but is it...
Identity in a table used previous number - Hi all, I have something that does not make sense to me. If anyone can give me clues that will be...
Unable to run the restore command in Node2 from Node1 part of Alwayson DB addition - declare @databasename nvarchar(max) declare @sqlbackup nvarchar(max) declare @sqlrestore nvarchar(max) declare @PrimaryAG nvarchar(max) declare @SecondaryAG nvarchar(max) declare @backupPath nvarchar(max) declare @linkedserverName sysname select @sqlrestore = N'RESTORE DATABASE ' + QUOTENAME(@databasename) + ' FROM...
How to use 'between' in CASE statement? - Hi Friends, I am trying to wirte a filter condition in WHERE clause like CASE WHEN GETDATE() = 'first of this month' THEN 'DATE...
SSMS 2016 13.0.1601.5 Update Not Complete - Ok. Every time I open my SSMS 2016, the update is returning the following. Obviously I ran the update and...
What can cause a failure in SQL Server, when a prior admin's account is deleted? - We had a prior DBA that had his AD account showing up as the owner on a multitude of SQL...
Stopping Service in Cluster - Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen? Will stopping SQL Server resource or...
Availability Group Listener - We have Always On with 3 nodes on that first 2 nodes are SQL Server cluster and 3rd node is...
Single Node MSSQL 2012 cluster to Always on - We need to migrate one of our MSSQL instances in Production . The outgoing replication is to Informatica and is very...
TEMPDB log growing HUGE - Running SQL 2012 SP3 CU6 AlwaysOn.... we had an issue two nights ago with the tempdb log filling the log disk....
Insert new row into a table, but move the old row to an archive table. Trigger or SSIS? Table partitioning? - Hello, Basically the the subject line says it all. I have been tasked with populating an empty table, but any subsequent...
Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060. - Hello. We have a very large table in one of our MSCRM deployments that has 566 columns with a variety...
Insert data into a table without disabling the constraints (pk and fk) - Hi I am working with a t-sql code in SQL Server 2008 and would like to know if it is possible...
Setup of High avilability DB Mirroring + Log shipping - Hi In Local IDC High availability Database mirroring already configured since 5 years back with manual failover with no witness server....
Blank page generated between two tablix in SSRS - I have two tables in my report. First tablix, should be shown on first page Second tablix, should be shown on second...
Dealing with programmers - Hi Community, Dealing with programmers turns to be a difficult challenge, when they ignore his duties, because they do not have...
Copy data from flat file with multiple headers - Hi, I am trying to copy data from a flat file (CSV) which has multiple headers between the row values to...
script out database users for the selected database - Hi All, This might be old question but i am not able to find answer for this. Actually i am looking...
Error converting data type DBTYPE_DBTIMESTAMP to datetime. - Hi, I am running an SQL statement that connect ORACLE database to retrieve data. I tried to run my SQL in sql...
Inserting TAB into string - Hi all, This is for SQL 2000. I am trying to add a tab character to a string using char(9) but...
