Your actual issue is here:
' + convert(varchar(50), '
You have a CONVERT without a second argument. It could be you meant to include either the CONVERT in the dynamic SQL or you meant to have this part
' + [UserName] ) as JobName
as the end of your CONVERT but in either case, it doesn'...
@Lamak the object will exist in the real scope and he can select from it
Uhmm, even that, I'd take only SQL Statements with text like '%yourFunctionName%', and eyeball it and stop it immediately as a call would come. Anyway, Profiler client not started from the prod server itself, but another machine.
then I'd search for that statement in the sysmodules sys table
as long as filtering is appropriate, even a busy env would stand some actions collected with Profiler
I need synchronize a database(just new records maintaining the auto increment) with a new database(blank), maintaining auto increment and doubling the next data entered in both.
is there a setting that I apply on my server for me to achieve this?
sorry, my english is bad!
Do you think it would be worthwhile to provide hints as to what language to use for the syntax highlighting?
Sometimes I find the highlighting on SQL or VB.NET answers is more distracting than helpful; for example:
Converting MySQL select to PostgreSQL
Retrieving data from a VB.NET arraylist o...
I am having difficulty creating a junction table in a new database. I used these queries to create the tables:
CREATE TABLE dbo.EmployeeUnavailability
(
ID INT IDENTITY(1,1) PRIMARY KEY,
EmployeeName varchar(50),
Monday varchar(10),
Tuesday varchar(10),
Wednesday varchar(10),
Thursday var...
@Marian I found how to do this using Extended Events. Thanks @JNK and @Marian for making me think about it! I posted the question and answer on dba.se for future visitors.
well for instance you could enter !gi sticky fingers at DuckDuckGo and get a Google Image search for "sticky fingers". Not sure you would want to do that at work!
I found many articles on date formatting expressions in SSIS but I couldn't find one that specified how to get just the Year such as 13 for 2013 or 12 for 2012... I tried
DATAPART("yy",GETDATE())
but it gives me the same result as
DATAPART("yyyy",GETDATE())
I was thinking of a dirty/hack f...
@AaronBertrand Drag your miserable, grumpy, SO abusing, idiot slapping, lack of sympathy for dimwittedness but OTHERWISE all round good chap of a self back in here. It's far to SO friendly at the moment.
9
In all seriousness, I feel less smart lately as I'm not getting sufficient visibility of feckless SO questions to make me feel better about my own abilities
I personally would do this a bit different. Since you are trying to pivot two separate columns that screams to use the UNPIVOT function.
The unpivot will convert your multiple columns into rows to then pivot.
Since you have SQL Server 2008, you can use CROSS APPLY and values:
select id, cour...
so we're going to troll the mods and then berate them until they learn to ignore flags in The Heap? GOOD CALL! We have our plan ... now ... bring me that horizon
This room was placed in timeout for 1 minute; the topic of this room is "General on- and off-site discussion for dba.stackexchange.com"; - conversation should be limited to that topic.
@Shog9 There was a comment earlier (by @Aaron) that was flagged, then 2 mods appeared here and the comment was deleted. And we guess that Aaron was banned due to that from chat for a while.
@Shog9 so the problem with network-wide moderation is that there's little understanding of the internal workings of each site. in this case there's a user who's arrayed against another ... flags ensue and a user gets banned. that seems a bit ... unfair, no?
@swasheck Normally, it takes a fair number of flags (6 I believe) to delete a message (and trigger a ban). If a moderator marks a flag as valid (or flags a post himself), then that triggers deletion + ban instantly. Moderators can also just ban people for arbitrary lengths of time.
If you feel a ban is unwarranted in a given situation, say something. They're easily lifted.
@Shog9 So if a couple of moderators with obviously differing views as to acceptable language happen to pile into an otherwise orderly room and elect to make their view felt...
@ypercube if you flag something mods will come, but those mods might not be used to general tone and attitude of a room. If you do choose to flag something as spam or offensive, the mods will look at this flag seriously on consider whether it is appropriate or not. The level of appropriateness is subjective however. What you might not find offensive, might be offensive to someone else.
well I guess that works... but when someone says "delete records every time you insert a record" I figure that is pretty dangerous advice. Not that any of us would follow that advice!
Hey. What a bunch of bullsh*t. Can't say f*ck in any context without mods coming in and stomping around like they own the place. We can't converse like adults here? I didn't say anything offensive to anyone. IMHO.
@Shog9 comments about why an answer as bad - whether you are the down-voter or not - lead to vengeful behavior in enough cases that I've really cut back on doing it.
@Shog9 sometimes I'll comment before there is a down-vote. But once one is there, I've seen way too many cases where the person gets defensive and then suddenly I have a couple of unexplained down-votes on my own answers (or worse, as I'm sure you're aware from meta and our own private conversations).
Anyway I think the mods are too quick to treat us like children. Just another reason this place has become quite less useful and attractive to me of late.
@MaxVernon it is right, flags should not be used for bad answers. Flags are for answers that aren't answers - should have been a comment, spam, etc. Bad answers are still answers and that's what down-votes are for (and comments, but I just explained why I've been doing less of that).
@Shog9 is a good dude. These other mods that jumped in here, well, since I can only judge them on that one interaction...
You don't have to comment when you down-vote. But if you're flagging - essentially asking a moderator to delete the answer - then it helps a lot if there's a visible indication as to why the answer is so harmful that simply down-ranking it isn't enough. Whether that's a comment, or in the flag itself.
@AaronBertrand If you have time to read all the thread of the last hour, it only needs: 1 user that flags a comment 1 mod (from another site who gets attracted by the flag and is not very lenient n "curse" words or is rather hasty) to delete the comment and the commenter get banned.
@AaronBertrand On that... Like it or not, you offended someone here. What you wrote may have been acceptable to the majority here, but at least one person was upset by it.
@AaronBertrand I find it far more likely that someone was irritated that you can answer pretty much any SQL question with thought and balance, and they wanted to punish you. (keep in mind I didn't see the original comment that got you banned)
@AaronBertrand Keep in mind, this is also the primary chatroom for dba.se - so you're gonna tend to get folks visiting it who aren't necessarily familiar with chat at all, much less this room's specific culture.
@Shog9 We have answered questions from randoms that have dropped in. Without them even asking a question on the site. Try to guide them, but they don't always :)
Guys, as long as you make it clear that there might be some rough language and all agree on what's acceptable, you shouldn't need to flag anything unless it does really out of of hand. People say dumbshit all the time, just look past it and move on.
Your actual issue is here:
' + convert(varchar(50), '
You have a CONVERT without a second argument. It could be you meant to include either the CONVERT in the dynamic SQL or you meant to have this part
' + [UserName] ) as JobName
as the end of your CONVERT but in either case, it doesn'...
I need synchronize a database(just new records maintaining the auto increment) with a new database(blank), maintaining auto increment and doubling the next data entered in both.
is there a setting that I apply on my server for me to achieve this?
sorry, my english is bad!
I am having difficulty creating a junction table in a new database. I used these queries to create the tables:
CREATE TABLE dbo.EmployeeUnavailability
(
ID INT IDENTITY(1,1) PRIMARY KEY,
EmployeeName varchar(50),
Monday varchar(10),
Tuesday varchar(10),
Wednesday varchar(10),
Thursday var...
I found many articles on date formatting expressions in SSIS but I couldn't find one that specified how to get just the Year such as 13 for 2013 or 12 for 2012... I tried
DATAPART("yy",GETDATE())
but it gives me the same result as
DATAPART("yyyy",GETDATE())
I was thinking of a dirty/hack f...
I personally would do this a bit different. Since you are trying to pivot two separate columns that screams to use the UNPIVOT function.
The unpivot will convert your multiple columns into rows to then pivot.
Since you have SQL Server 2008, you can use CROSS APPLY and values:
select id, cour...
I was wondering if there is a way to find out the number of active locks held on a table in SQL Server?
