Viewing 15 posts - 1,051 through 1,065 (of 13,465 total)
specific error is probably helpful; i suspect it's the column name is misspelled due to copy paste?
or is it because the table busidentity is not in the join criteria on...
May 9, 2016 at 6:33 am
there's a pair of functions that you can use to get either the things the views reference, or the things that the view consumes.
--objects that USE the views
SELECT
schema_name(vwz.schema_id) As...
May 8, 2016 at 7:21 am
that's a tough one, since the bat could be doing anything, and it's outside of SQL server.
you could open up Task Manager on the server, but the real question is...
May 7, 2016 at 8:35 am
i have specific jobs that are identical on all servers, things like backups, statistics, indexing.
i connect via Central Management servers, and run the create job script on all of them...
May 6, 2016 at 3:42 pm
PJ_SQL (5/6/2016)
I have SSIS 2012 (SSDT) residing in one server and I need to run the SSIS package from a different server.What is the process for that?
not quite sure what...
May 6, 2016 at 1:09 pm
a really nice feature is you an update on a cte affects the base table, so if you generate an identifier for dupes, you update everything that is a dupe.
WITH...
May 6, 2016 at 12:03 pm
so your applicaiton has sysadmin rights, and whenever it creates a login, it makes it sysadmin, and then adds a user i guess.
if you kill it in a trigger, you'll...
May 6, 2016 at 11:42 am
SqlBarbarian (5/6/2016)
May 6, 2016 at 11:01 am
remember there is a difference between a LOGIN and a USER.
nothing gets any rights unless you add them to a group or role that gives them permissions.
so, never add a...
May 6, 2016 at 10:54 am
obfuscate object names? that might make things difficult to get help with, because someone might suggest a change to the schema of a table, you have the mapping issue; but...
May 6, 2016 at 9:53 am
ok, here's how i would tackle it;
assuming your analysis on the two chars is correct, this produces both "versions"
of the data;
now i would simply test for high ascii, and take...
May 6, 2016 at 8:50 am
SQLRO (5/6/2016)
STUFF(column_name,1,1,'') then it removes 02 as that is the first character in binary and makes the binary pattern as 0x31...
May 6, 2016 at 8:10 am
I'm always confused about what a data analyst title really covers as well, i tend to think of it as using statistics to find both trends and outliers, maybe with...
May 6, 2016 at 7:24 am
wow that's an interesting puzzle.
so is the varbinary string stored as a string datatype, or is it a varbinary(max)?
for a solution , we need the datatype as it is stored...
May 6, 2016 at 6:56 am
unless you have an extended event or audit already in place, you cannot capture that data; SQL executes a query and throws it away, but it might save the plan(the...
May 6, 2016 at 6:27 am
Viewing 15 posts - 1,051 through 1,065 (of 13,465 total)