Viewing 15 posts - 1,651 through 1,665 (of 8,760 total)
February 13, 2018 at 9:25 am
February 12, 2018 at 9:45 am
February 12, 2018 at 8:48 am
Beatrix Kiddo - Monday, February 12, 2018 2:31 AMI'm going. My employers actually agreed to pay.
Good stuff, there should be more of...
February 12, 2018 at 8:40 am
krypto69 - Monday, February 12, 2018 8:23 AMLooking to script out a DB every night as a job.How can I accomplish this?
May...
February 12, 2018 at 8:38 am
February 10, 2018 at 1:23 am
Of course you could also do this (will need some changes if you have...
February 9, 2018 at 1:37 am
I'm needing to split a 60 character string every third character with spaces/pipes and...
February 8, 2018 at 9:54 am
February 8, 2018 at 9:51 am
IIRC, there should be a double backslash for the share names
😎
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d LL_DB -Q "EXECUTE [dbo].[DatabaseBackup] @Databases = 'AVAILABILITY_GROUP_DATABASES', @Directory = N'\\backup\SQL\Drive1\,...
February 8, 2018 at 2:19 am
February 6, 2018 at 2:15 am
You can use BCP to export the XML to the file system
😎
January 31, 2018 at 12:24 pm
Quick suggestion
😎USE TEEST;
GO
SET NOCOUNT ON;
SELECT
OBJECT_SCHEMA_NAME(SCOL.object_id) AS SCHEMANAME
,OBJECT_NAME(SCOL.object_id) AS TABLENAME
,SCOL.name AS COLUMNNAME
FROM sys.columns SCOL
INNER JOIN ...
January 30, 2018 at 3:38 am
Here is one way of doing this
😎
USE TEEST;
GO
SET NOCOUNT ON;
CREATE TABLE #UserActivity (
[User] int NOT NULL,
ActivityTime datetime NOT...
January 30, 2018 at 12:34 am
DamianC - Thursday, January 25, 2018 6:24 AMThanksSo does use="required" actually do anything
Presumably, I just use minOccurs="1" maxOccurs="1" rather than use="required"
Sorry, didn't...
January 25, 2018 at 6:48 am
Viewing 15 posts - 1,651 through 1,665 (of 8,760 total)