Forum Replies Created
Viewing 15 posts - 4,981 through 4,995 (of 13,460 total)
-
RE: Equivalent to "#INCLUDE" Preprocessor Directive in T-SQL?
there is no equivilent; each SQL statements kind of assumed to stand alone, and would need everything it needs inline with the command itself, sorry.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: problem with Database mail:All mails have Unsent status
run this query, and review the err.description:
they probably all have the same error message..it might say 5.7.1 relaying prohibited, or 551 mailserver not found, etc.
post one of those error messages...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Update index stats on 1 table fixed performance problem?
I thought sysindexes is deprecated.
and that made sys.sysindexes the replacement?
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Update index stats on 1 table fixed performance problem?
rebuilding an index only builds the statistics on the columns included in the index; it doesn't do the whole table. so if the statsitics are out of whack for...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: unique constraint
there is a drop down menu in the screen shot...right now it says "Index"
if you chose the other option in the list "Unique Key" it creates it as a constriant,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: unique constraint
sqlfriends (8/9/2012)
Thanks, so this is to create a unique index, but not a unique constraint.It seems not GUI way to create unique constraint.
i think it's more of just a naming...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: unique constraint
it's there.
it's an option when you go to create or edit an index
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Best Role to to create, update and read tables.
Sqlism (8/9/2012)
Great! This really helped me a lot lot lot.Thank you:)
Excellent! Thank you for the feedback!
I like trying to provide examples, it's much easier to help folks visualize and...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Encryption
As Far As I Know, if you lost the passPhrase for creating the certificate, you would also lose the ability to decrypt anything that was encrypted with it.
if someone...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: procedure started taking longer time to retrieve data in last two days
it's LinkedServerName.DatabaseName.User/SchemaName.ObjectName.
you want two periods together to hide databasename for Oracle; your example has 3 periods.
'EDWGEARS..ORAUSER.VW_FRED_AADT_HIST'
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: procedure started taking longer time to retrieve data in last two days
username/owner of the table? probably is' like
EDWGEARS..MYORAUSER.VW_FRED_AADT_HIST.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Best Role to to create, update and read tables.
I think it's a best practice to create your own role that encapsulates just the required permissions.
Then i can assign any number of users to that role, as it's appropriate.
this...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: T-sql Via Linked server - MySQL
glad i could help!
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Trigger to rollback if no PK assigned
lol i was testing a different forum post and got stopped by this trigger!
that's hilarious for me.
i went ahead and dropped it on my server now 🙂
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Encryption
Encryption was introduced in 2005, but the methods are still teh same, even for 2012;
I relaly liked this article enough to bookmark it: and keep it and it's code in...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 4,981 through 4,995 (of 13,460 total)