Forum Replies Created
Viewing 15 posts - 10,906 through 10,920 (of 13,460 total)
-
RE: Replacing misspellings in a string
i have already done something very similar...this code may help out, or just complicate matters...
it's a huge stack of updates to a temp table, so I could review the old...
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: dynamic sql - string being truncated issue
you error message is not related to your (max) string, it's related to a specific varchar/char column in the sql statement you built...
if a column has a definition of 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: Determining when database was last accessed?
ahh i see what you are after...i think you'll end up finding that all the DMV's get set to zero whenever the server is stopped and started, though right?
so...
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: Triggers - Database to Database
i think the original poster wanted a different database, not necessarily a different server, right?
a simple trigger like:
CREATE TRIGGER TR_MyTrigger On SomeTable
FOR UPDATE
AS
BEGIN
UPDATE MyAlias
SET col1 = INSERTED.col1,
col2=INSERTED.col2
...
FROM INSERTED
INNER...
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: Determining when database was last accessed?
jabba (6/30/2009)
My understanding is that the server side teace will not be retrospective and so will not achieve what I am looking for. I go back to my original question....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 Calculate Database Transaction Execution time
not enough information to help you; you can see how long a command took with a trace or by setting SET STATISTICS TIME ON , but not an estimated time,...
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: Is it Possible
your co workers are under informed, I think.
when you move the primary key/clustered index of a table to a new file group, you move it's data as well.
example:
CREATE...
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: ODBC Connection dropped
there's a pretty good thread on the issue here, but it may or may not be the same thing you are experiencing:
it seems the default behavior of SQL 2005 changed,...
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: Database Setup Information is invalid
well, just as the error message says, the first thing I'd do is check to see if the server allows remote connections:
This issue vs your credentials in your signature don'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: Execute stored procedure in AFTER UPDATE trigger
the above trigger example assumes thre would only be ONE row ever updated at any one time...it best practice is to assume more than one row comes from the INSERTED...
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: Very confusing "Error converting data type numeric to numeric" SQL Error
yeah i agree; either fix the data, or the one parameter raising the issue. I would not try to change hundreds of other parameters...to many things for the QA team...
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: Very confusing "Error converting data type numeric to numeric" SQL Error
@Param1 NUMERIC(2, 0)---this says the definition is 2 digits, none after the decimal....but you are assigning a 5 digit number to it: @Param1 = 92229.0
since the biggist...
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: Help Needed ???
he can use a case statement to group them horizontally;
well...three case statements, right?
case
when c1 <= c2 and c1 c1 and c2 <= c3 then c2....
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: Restore database without restoring data
RESTORE DATABASE myDatabase WITH RECOVERY would work only if there is already a backup in place and you want to restore the default backup. if this is on a diffrerent...
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: Restore database without restoring data
you'll want to read up on RESTORE from Books online; if you are restoring from a file, the command would look something like this:
RESTORE DATABASE [YOURDB]
FROM DISK =...
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 - 10,906 through 10,920 (of 13,460 total)