Forum Replies Created
Viewing 15 posts - 1,831 through 1,845 (of 13,460 total)
-
RE: Error handling with in cursor
so, if your cursor were going to loop through 50 tables,
and you get an error on table #30, do you want to rollback just table30, or the 29 previous...
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 there a way to access a movie on a dvr through a SQL Report
this is effectively recreating the wheel, isn't it(youtube.com?)
Like Sean said, i doubt you'll have an API to push around a DVR; i've never seeen or heard of one.
if you have...
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 me with the Select Statement for date formatting
convert has an optional 3rd parameter:
--2015-04-06 16:13:21.187
SELECT CONVERT(VARCHAR,getdate(),121)
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: Incorrect Syntax error. But the generated query is good
also, use quotename around your db variable; sharepoint databases often get created with hyphens, and hyphens or spaces int he naem will break your script
SET @sql = 'USE ' +...
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: Delete Before Insert Trigger Statement
deleting and inserting again where the your Id already exists is exactly what an update actually does...
it sounds like if you cannot fix the applciation/datastream to know it has an...
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 can I create my own custom SSIS 2008 SFTP Component?
as i remember it, pragmatic works is around 1500 bux, which would save you weeks of self development anyway.
certainly a good option, in my opinion.
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 can I create my own custom SSIS 2008 SFTP Component?
there's an older 2008 version here, which can be compiled:
SSIS SFTP Task v1.5 for SQL Server 2008
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 can I create my own custom SSIS 2008 SFTP Component?
you did see that that project contains the complete source code, so you can compile it yourself, right?
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: Running Ola script and getting error
ok, i see what the others were saying now.
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES, -Prod',
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 can I create my own custom SSIS 2008 SFTP Component?
i've used this open source project several times:
https://ssissftp.codeplex.com/
no sense reinventing the wheel, if it's open source, you can rename it, taking care to leave credit where credit is due, 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: Running Ola script and getting error
for the specific database you exclude, is it a database snapshot, or offline or read only ?
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: syntax error
easy fix.
@temp variables go out of scope when you call it in the msdb.dbo.sp_send_dbmail call , so you'll have to change it to a #temp table instead.
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: Easy way to copy & empty a DB
in a general sense yes,it's probably good for 90% of what you need, but depending on your settings for your scripting options things can NOT be scripted. that's why 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: Easy way to copy & empty a DB
well, a snapshot is a readonly version of the existing database at the point in time you create the snapshot;
so it's basically still the original database, but saying ignore...
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: Easy way to copy & empty a DB
You are on the right track, i'd say;
i would go with the backup-restore-delete specifics route, same as you are thinking.
it guarantees to not miss any objects, and there's always certain...
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 - 1,831 through 1,845 (of 13,460 total)