Viewing 15 posts - 1,591 through 1,605 (of 6,401 total)
Will be exactly how you call the CONCAT function and how you have already discribed it
CREATE FUNCTION dbo.my_func (@string1 varchar(10), @string2 varchar(10),............, @stringn varchar(10)
...
...
...
dbo.my_func ('string1','string2',.....,'stringn')
December 21, 2015 at 6:22 am
Eirikur Eiriksson (12/21/2015)
djj (12/21/2015)
anthony.green (12/21/2015)
Ed Wagner (12/21/2015)
Grumpy DBA (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
whereisSQL? (12/20/2015)
AwesomeEverything
Something
Nothing
NULL
Unknown
Knowledge
Useless
Chocolate Fireguard
December 21, 2015 at 5:51 am
Ed Wagner (12/21/2015)
Grumpy DBA (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
whereisSQL? (12/20/2015)
AwesomeEverything
Something
Nothing
NULL
Unknown
December 21, 2015 at 5:30 am
Are BizTalk and SQL on the same box? If yes, then you could potentially run into an issue if MSDTC wants to use one of the SQL Ports
December 21, 2015 at 2:28 am
Depends on the corruption
What is the full output of
DBCC CHECKDB <<DBNAME>> WITH NO_INFOMSGS, ALL_ERRORMSGS
When was your last good backup?
December 21, 2015 at 1:24 am
ALTER SCHEMA dbo TRANSFER MDCH.Hist5657;
GO
December 18, 2015 at 7:23 am
Check the job history in Job Activity Monitor or MSDB, it should detail who started the job.
December 18, 2015 at 2:24 am
It all comes down to how you want to manage security?
Can you allow the same account to connect to all databases? Does this pose a security risk to your...
December 18, 2015 at 1:58 am
Did you change the accounts back to the original service account prior to doing different ways?
IE if you used services.msc first, did you then go straight to SSCM or did...
December 15, 2015 at 8:40 am
How did you change the service account?
Services.msc or SQL Server Configuration Manager?
December 15, 2015 at 8:32 am
This isn't a SQL Express install by any chance is it?
December 15, 2015 at 7:58 am
Will it work - Yes
But from your first post, using it for reporting, using Developer edition will breach the T&C's you accept at install time
December 15, 2015 at 7:28 am
Restore the backup as another name, then use T-SQL or SSIS (Import/Export Data Wizard) to move the data from tables in question
December 15, 2015 at 6:12 am
Have you given permissions at the root and worked them down the folder structure, or given them at the individual report level?
December 15, 2015 at 3:04 am
Viewing 15 posts - 1,591 through 1,605 (of 6,401 total)