Forum Replies Created
Viewing 15 posts - 9,181 through 9,195 (of 13,460 total)
-
RE: Back up and Performance issue
well i saw one thing we can fix right away so far:
there is a scalar function dbo.Get_LocalDateTime that is called multiple times; that needs to be changed to a inline...
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: Error on BCP export into .CSV file via xp_cmdShell
keyun i'm sure the issue is related to attempting to use a trusted connection.
if you pass a SQL username and password, your command to bcp via xp_cmdShell will owrk.
to see...
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: Back up and Performance issue
sam-1083699 (6/24/2010)
HI Friends,I'm currently working on a server where lot of transactions will be running and this server is a very beefy server with 4 quadcore processes for a...
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: Error on BCP export into .CSV file via xp_cmdShell
you cannot use a trusted connection via sp_cmdShell. SQL doesn't use your credentials after you've connected to SQL.
this is a common security misconception. The problem is that when you...
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: Open a csv file do Find and Replace
you do not need to put the command in a while statement; .Replace will replace all instances of the comma in one single function call.
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: XACT_ABORT and RAISERROR relationship
there is a Connect article about how Raiserror does not work the same with XACT_ABORT ON as it does when in a try catch block:
http://connect.microsoft.com/SQLServer/feedback/details/275308/have-raiserror-work-with-xact-abort
annoying, you would expect raiserror to...
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: Send e-mail based on criteria from script
yeah configuring the server like that is something you like once a year at the most, and only when you needed a functionality you didn't need at startup;
glad i could...
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: How to create SQL Server 2008 Policy that prevent a table to be deleted
instead of having a rollback command as the body of the trigger, you can send an email instead....so you can get notification that it ALREADY happened and not rollback the...
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: Send e-mail based on criteria from script
in small letters, right next to the words "Configure Surface Area for localhost" there is a link that says "change computer"
click it and put in the name and connection info...
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: Send e-mail based on criteria from script
the error is self describing...go to Start>>Programs>>Microsoft SQL server and find the Surface Area Configuration....scroll down to database mail and enable it.
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: How to create SQL Server 2008 Policy that prevent a table to be deleted
you want to prevent one specific table or all tables from being dropped?
i assume you mean some people have the rights/roles to drop the tables, you are not going to...
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: How to imbed an image into an email sent by dbmail
the secret is to use cid:attachedimage.gif for the source file.
here's a setup and working example:
I'm attaching the results of a query, and i copied the SQl server logo to my...
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: Funtion to calculate turn arround time time between two dates
Note that this has syntax issues with what stewart posted if you are not using SQL 2008; 2005 hates you for a few things (no += operator, can't...
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: Relationship advice
can any Organization have more than one CompanyNumber a CharityNumber?
if the answer is no/never , i'd put those columns in the Organization table; if the answer is maybe/not sure, i'd...
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: Sql Doubt - 1
boy these read just like homework questions.
what do you think the answers are?
troy2.net (6/23/2010)
1) Can we generate Trigger for two table and give a example ?you can create a...
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 - 9,181 through 9,195 (of 13,460 total)