Viewing 15 posts - 796 through 810 (of 6,036 total)
Well, I managed to see it, so you should be able too.
Just look at the right places - system objects in databases where user objects are created/modified.
Since you say...
July 4, 2017 at 5:26 am
July 4, 2017 at 2:35 am
July 3, 2017 at 7:43 pm
Do you have in the code something like this?DECLARE @var Datatype = dbo.SomeFunction(@params)
July 3, 2017 at 7:57 am
I would check how many unique location are stored in the table.
If there are no too many of them then I'd create a cursor for DIR each of them, no...
June 30, 2017 at 11:15 pm
Restore the database on the new server from the full backup.
Establish log shipping. Make it often - every 1 or 3 minutes.
Once Restore log has caught up with...
June 30, 2017 at 7:33 pm
The solutions posted seem to have too twisted logic.
A bit difficult to follow.
I believe it must be way simpler.
First part is obvious:declare @From...
June 29, 2017 at 6:55 am
Just tried to load CSV file with freaky quoted values into LibreOffice Calc - works perfectly.
MS could contract those programmers...
June 29, 2017 at 2:09 am
Are you loading the last empty row from the file?
June 29, 2017 at 12:15 am
June 29, 2017 at 12:07 am
Jeff Moden - Wednesday, June 28, 2017 6:55 AMHeh... what's the last cursor you wrote and what did it do?
I can...
June 28, 2017 at 7:08 am
[OrderId] [uniqueidentifier] NOT NULL,
.......
CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED
(
[OrderId] ASC
)
Nothing much to save here.
PK on an uniqueidentifier column, and it's clustered.
You've...
June 28, 2017 at 6:53 am
It actually is in my list. Even though it's a bit of a...
June 27, 2017 at 10:42 pm
June 27, 2017 at 4:49 pm
Viewing 15 posts - 796 through 810 (of 6,036 total)