Viewing 15 posts - 1,321 through 1,335 (of 7,187 total)
You don't appear to have attached errors.txt. In SQLProfile_Resolve_Text.txt, are the last few lines (starting with the line that begins with SELECT) the contents of the @Query variable? Have you...
August 9, 2017 at 2:28 am
Failing in what way - error messages, wrong results, just doesn't do anything? Please post an example of the @sql that you get from test.sql and the full definition of uspCloneTableWithQuery....
August 7, 2017 at 6:17 am
No, you can't do it like that. You need one "?" per parameter and you need to lose the single quotes from the code in (1). If you want to...
August 7, 2017 at 2:19 am
No, I don't think so. As far as I know, the query optimizer doesn't take permissions into account when compiling an execution plan. And if you think about it, that...
August 3, 2017 at 8:20 am
But you said you had 100 users? And you mentioned developers - surely they don't access the database through a website? Never mind - create the login, create a database...
August 3, 2017 at 6:59 am
No, it can't be done with the connection string. Even if it could, you wouldn't want to, since any user with a little know-how can write his or her own...
August 3, 2017 at 5:58 am
Yes, you haven't provided enough information for us to answer properly. But if you can't or won't use a linked server, then try SSIS or OPENROWSET.
John
August 3, 2017 at 5:47 am
Yes, or return dates as dates, and if you need to make it all look pretty, do that in the presentation layer.
John
August 2, 2017 at 2:57 am
I'm not sure this a shortcoming of PowerShell. The standard installation of Windows doesn't include the Active Directory management tools. If you add that particular feature, you get the Active...
August 2, 2017 at 2:38 am
I'm not sure whether sqlcmd comes with the full product or just with SSMS either, to be honest. But, despite the hollers of protest, we don't install SSMS on servers,...
July 31, 2017 at 4:23 am
The script I use isn't quite as sophisticated as Thom's. However, what I do is keep the options in the config file to an absolute minimum, only specifying what has...
July 31, 2017 at 3:39 am
Faster than what?
The short answer is probably this: it uses its own compression algorithm that is more efficient than that in native backups. The long answer? Probably best...
July 31, 2017 at 2:57 am
Arshad
I'm not sure what he means by the metadata in the new binaries. Everything that's in the database is backed up with the database. Sure, there are some...
July 27, 2017 at 4:37 am
Arshad
I'm sure (s)he'll be able to explain why (s)he thinks that! If it doesn't sound right to you, please post back here.
John
July 27, 2017 at 3:25 am
Yes - everything that is part of the database is backed up in a full database backup. Is it really important, though? It's easy enough to rebuild the statistics after...
July 27, 2017 at 2:26 am
Viewing 15 posts - 1,321 through 1,335 (of 7,187 total)