2014 SSMS - SA Account password changing on it's owm - how to get rid off this issue. - Guys, Have you ever heard of the the SQL password changing on it's own - for our software the SA password? I...
Avoid Blank Values in a column - Hi All, I need to avoid/deny blank values/empty string ('') entered into few columns in a table. This column already does not...
Trouble Deploying CLR functions - I have some CLR functions that were compiled and under .Net framework 2.0 for SQL Server 2008. I modified and...
How do I install AdventureWorks in my local PC - I have SSMS installed on my PC. However, I am not able to install the AW database on my local...
Query slow just once a day - OK, this is driving me nuts. I have a query that runs slowly once a day (2 minutes) and then...
Add Date Stamp to File created using 'INTO' Statement - Hi Forum, I'm creating a file each day that is created as follows; [quote][/Select a,b,c, INTO dbo.MyResults from Table1 quote] I would like...
That old conversion failed Date Time error - Hi All, Apologies if I have committed a sin but am starting a new thread after updating another as this is...
Finding retention of a person - I would like to ask if anyone would be able to help out with this. I would be more than...
generate unique id for each row within a range - Hi All I want to assign one unique id to each row in a table and the range is from 1...
Trim string based on characters - Hi, I have strings like WebApp - 10148 Smart - App - 1458 [b]Expected Result[/b] WebApp Smart - App I want to trim the characters from - to numbers from right. I...
Correct DataType? - If I have a user entry field that could hold a bible of information and could have formatted text (carriage...
Looping and scalar value - Hi No doubt this is standard behaviour I should already know about, but I'm a little unclear about it. The example...
Set @var being used in Where IN - I am trying to set up a variable @Location, for use in a where .. IN, but can not seem to...
0 is equal to zero length string. Can someone explain how this can be? - --I know this has to do with an implicit conversion of the varchar to int, --but why does the zero...
xp_cmdshell exec ssis package in 32bit mode - I have a package set to run in 32bit mode on a 64bit machine, and I need to put it...
How to find out what databases have not being used for a year - Hello, I started working in a company where we have 6 production servers with a lot of databases on each...
SSIS package creation with txt file having multiple select statements - Hi, I have a TXT File with 20 Select statements. Requirement is Execute each Select statement and Email the output in CSV...
Import Excel binary files into SQL Db using SSIS - Hello, I have a several .xlsb (MS Excel binary) files with data that I need to import into a SQL...
Backup job fails with Error 3013 - I have a backup job that takes a full backup of my production database on a daily basis. It was running...
Wildcard parameter for multiple searches - I have put this here as although it is an SSRS report I am building I am starting with the...
