Viewing 15 posts - 2,416 through 2,430 (of 5,109 total)
This sound like you're saying you don't normally do a transaction log backup? Do you? What recovery model in your database in?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 8:41 am
Thanks but i solve the problem assigning values to my DECLARE variables:
DECLARE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 8:21 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 8:18 am
Also, you're naming convention seems wrong. You use: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.FROM ' + @dbname + '[.bo]
If you're including a database name, then you'll need to use 3 part naming convention:[database].[schema].[object]
Larnu.uk
December 12, 2017 at 8:06 am
luissantos - Tuesday, December 12, 2017 7:46 AMi always have the same error
And that error is..? 🙂 We can't run your SQL,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 7:50 am
I'm actually a little concerned what our VA report is going to look like. Time to find out! 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 7:09 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 6:05 am
This is a little bit of a "quick answer", as I'm sure there's faster, however, you could use the DelimitedSplit8K function:SELECT t.StudentID,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 5:59 am
etirem - Tuesday, December 12, 2017 5:13 AMyes and yes for above questions.
It can't be both... If I have the delimited list...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 5:21 am
Sounds like the SA account has had it's sysadmin privs revoked, and not had a user created on the database.
Out of interest, what does the following return?USE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 5:09 am
unas_sasing - Tuesday, December 12, 2017 4:32 AMfrom 2-29, how to make the opposite become 29-2 ?
Could you rephrase your question?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 4:59 am
If not the same number, is it the order in which they appear in the delimited list? (which, in your examples is the same, but who knows for your real...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2017 at 2:12 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 11, 2017 at 1:08 pm
Does anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 11, 2017 at 12:31 pm