Lowell

Forum Replies Created

Viewing 15 posts - 11,671 through 11,685 (of 13,460 total)

RE: Backup database on a host provider

search the scripts section for "generate scripts"; there are plenty of examples there;
however, teh builtin stuff works great: rightclick on your db...tasks...generate scripts.
a wizard will appear and just tell 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!

February 2, 2009 at 6:53 am

#936393
RE: Backup database on a host provider

I've dealt with a couple of shared hosting providers.(ihostasp.net,godaddy.com)
They always give you an interface so you can run SQL statements, batches, etc...you just have to realize, in a shared...
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!

February 1, 2009 at 9:41 pm

#936242
RE: DateTime rounding of milliseconds in SQL incorrect

well, SQL servers datetime datatype is only accurate to 3 milliseconds increments...so if you try to increment by milliseconds it goes from 0,3,6,9 all the way up to 997
to preserve...
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!

January 30, 2009 at 4:27 pm

#935900
RE: import data in sql server 2005 express edition

import and export of any kind, where thru the Management Studio or SSIS, are only part of Standard,Enterprise and Develoepr editions; they are not included in the freebie versions.
your best...
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!

January 30, 2009 at 11:30 am

#935755
RE: Monitor a table

going back to your specific issue....the Service Broker job can be scheduled to run every minute...
say you have a trigger that puts an event in the new Tracking table instantly...that's...
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!

January 30, 2009 at 8:42 am

#935605
RE: Monitor a table

I guess you missed my point; you can have a trigger that does whatever the trigger needs to do. no problem.
but that is separate from an email notification that...
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!

January 30, 2009 at 8:32 am

#935593
RE: Unable to connect to an Access database

you probably have it open in Access to look at the data at thesame time you are trying to access it via code:
It is already opened exclusively by another...
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!

January 30, 2009 at 8:02 am

#935568
RE: Monitor a table

I don't think you need a trigger for htis....you need a tracking table to determine whether an email should be, or has already been sent.
if the table you have 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!

January 30, 2009 at 7:57 am

#935559
RE: Cascade update

when you create a foreign key, you can add the extra commands ON UPDATE CASCADE ON DELETE CASCADE, and then changes to teh parent will automatically propigate to the foreign...
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!

January 29, 2009 at 10:29 pm

#935288
RE: Urgent HELP ME¡¡¡¡¡¡ Some one

doh i should have thought of that...edited.
I took some spanish in school, but living in South Florida, I get to struggle with it a bit, just enough to try 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!

January 29, 2009 at 9:36 pm

#935274
RE: Need help with a simple query

ok, now as best as i can figure, you wanted to update one specific row, where QuestionID='1773', with the sum of all the Answer_Int for a group of specific questions.
i've...
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!

January 29, 2009 at 9:19 pm

#935269
RE: Need help with a simple query

I don't know your table structure...i just wanted to demonstrate that you can have an update that comes from a sub query as well as other values....use this as 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!

January 29, 2009 at 8:40 pm

#935251
RE: Urgent HELP ME¡¡¡¡¡¡ Some one

quisiera saber como poder hacer que se guarde el log de mis dts en una tabla especifica , o como hago para que mis dts guarden el log de la...
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!

January 29, 2009 at 8:24 pm

#935244
RE: Export table data to flat file

the number one tool to export SQL queries and tables to disk would be BCP; you can decide what the delimiters would be, ie commas or tab delimited, or even...
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!

January 29, 2009 at 8:12 pm

#935239
RE: Need help with a simple query

The format of your current update from is a lot like what i've seen in Oracle and PLSQL;
SQL server supports a different format that, at least for me, seems more...
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!

January 29, 2009 at 8:07 pm

#935236

Viewing 15 posts - 11,671 through 11,685 (of 13,460 total)