Viewing 15 posts - 2,866 through 2,880 (of 8,761 total)
There can be more than one reason for this error, ie. wrong path specified, insufficient permissions, destination marked read only or not enough space at the destination.
😎
November 8, 2016 at 3:13 am
abhas (11/7/2016)
Thank you so much Eirikur and David.
Really appreciate your efforts. Its working as per requirement.
Only one issue - when same firstName and LastName comes then creating only one...
November 8, 2016 at 1:27 am
Does the query use DISTINCT?
😎
November 8, 2016 at 12:37 am
Another option I've been using for similar purposes is the dynamic management view sys.dm_db_index_usage_stats, monitoring the changes in user_updates using last_user_update and index_id < 2 to limit the output. The...
November 8, 2016 at 12:09 am
mister.magoo (11/7/2016)
mister.magoo (11/7/2016)
Documentation is slippery... but here is the event
select p.name, p.description, o.name, o.descriptionfrom sys.dm_xe_objects o
join sys.dm_xe_packages p
on p.guid = o.package_guid
where p.name='sqlserver'
and o.name like 'table_update_code_path'
I have to say though -...
November 7, 2016 at 11:43 pm
David Burrows (11/7/2016)
WITH x (ID,FirstName,LastName,UserName,UserNum) AS (
SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,
ROW_NUMBER() OVER (ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC,LEFT(e.FirstName,t.N)+e.LastName ASC,ID ASC)
FROM #Employee e
JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)
WHERE NOT EXISTS (SELECT * FROM...
November 7, 2016 at 10:58 pm
Here is a solution that works according to the current;-) requirements. It has a limitation of the first name being 30 characters or shorter, don't think that is going to...
November 7, 2016 at 10:48 pm
MiguelSQL (11/7/2016)
Ate you talking about the comnandlog table?It didn't have enough detail as the log file
It has all the backup file names, error code, error number, did you need any...
November 7, 2016 at 9:37 pm
Simple "set" based approach
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#mytab') IS NOT NULL DROP TABLE #mytab;
create table #mytab (origval varchar(max))
insert #mytab values
('1.2'), --should convert to 1.3...
November 7, 2016 at 2:14 pm
Henk Schreij (11/7/2016)
@ "Another question, how frequently will this be called?"Not so often:
From March till August at max a 100 times per hour. Rest of the year almost never.
Then this...
November 7, 2016 at 12:22 pm
Eric M Russell (11/7/2016)
Eirikur Eiriksson (11/7/2016)
Eric M Russell (11/4/2016)
November 7, 2016 at 12:16 pm
You are very welcome
😎
Another question, how frequently will this be called?
November 7, 2016 at 10:13 am
sqlfriends (11/7/2016)
front end .net developers
:exclamation: hopefully those are not doing any sql development :exclamation:
😎
November 7, 2016 at 10:07 am
Jeff Moden (11/7/2016)
Eirikur Eiriksson (11/7/2016)
Jeff Moden (11/6/2016)
November 7, 2016 at 9:58 am
Viewing 15 posts - 2,866 through 2,880 (of 8,761 total)