Topics
Started by
Posts
Last post
In a 2 node cluster, I can able to connect SSMS in Node 1 only. When i tried to connect in node2 i …
7 replies
Hello All, Basically I'm trying to use TSQL to convert user SIDS from Binary to String and visa ver…
10 replies
Hi All,My apologies if this is posted in the incorrect section, but I couldn't find a better one. 🙂…
1 replies
Hi All , I would like to know how often we need to update statistics for all databases ?I need…
6 replies
I know how to get the login name (ie: TheDomain\SpecificLogin1,TheDomain\SpecificLogin2, etc.), but…
2 replies
I am unable to start then SQL agent. getting below error message when i tried start the agent The S…
10 replies
Hi all, I've been trying for days to solve a seemingly simple problem. DECLARE @table TABLE (id INT…
12 replies
Hello All, I have two tables. The First table is staging table where I have data called MatCodeID,…
4 replies
Hi We're working on archiving or moving a huge dataset from one database to another (somewhere arou…
2 replies
Hi I'm trying to set a column name as the variable below Declare....Set @Month1s = cast(dateadd(mon…
1 replies
I have a stored procedure with a parameter. I would like to force the input to be at least five cha…
4 replies
Hi all, I have a table called Tbl_Authorized01, and I'm trying to find cases where a patient …
7 replies
I have SQL Server Management Studio 2016 installed on my PC.I am tryting to install RedGate SQL Dev…
2 replies
We have tables that partitioned on a daily basis. However one day 2011-05-24, was skipped by some r…
2 replies
This might sound very common question but unfortunately i haven't found a good script yet. I do use…
1 replies
Viewing 15 topics - 1,186 through 1,200 (of 30,225 total)
You must be logged in to create new topics.