Forum Replies Created
Viewing 15 posts - 2,356 through 2,370 (of 13,460 total)
-
RE: Where do I find Microsoft.SqlServer.Management.IntegrationServices.dll?
I believe you can extract it from the GAC:
C:\Windows\assembly on my machine, and i see
pulling stuff out of the GAC is tricky, i did it in the past 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: how to see discarded job history
like homebrew stated, it's easy to change the limits on the history:
right clicking on SQL Agent and go to Properties (in SSMS Object Explorer)
find the history tab.
Personally, I'd prefer 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 i make ERD Diagram for payroll salary for employees
i googled for "payroll database examples"
and went for images related to the search;
this is the first one tha it saw that appealed to me, but it's really up to 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: Insert triggers updating an audit table
once per batch.
you can get the count of records affected from the inserted table itself, if that's what you wanted to track:
SELECT COUNT(*) As RecordsAffected FROM 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: Build 2 hospital readmission tables
i just built this same report for my job...small world, what with the new rules for not getting paid if a re-admit occurs within 30 days.
without the sample data Sean...
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: Trying to Connect to SQLCMD for Some Reason Im unable to CONNECT to the SQL COMMAND.
there's not multiple instances, right?
you know you used lower case -s and not uppercase -S? and the parameter flags are case sensitive
based on what you posted, this should be working
SQLCMD...
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: Maint Plan Fails :-(
isn't that always the way it works?
i install all kinds of stuff locally, but never have time to dig deeper into the details...
until a fire comes along 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: What a weird case in SQL 2012 - Need Help!
so wierd;
i speak spanish, albiet not as a primary languange, but i had no trouble with the error messages, it's just the error says syntax near BEGI and not...
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: Need set based method to insert missing records into table - right join doesn't work
it took me longer to build your sample data from what you posted, than it was to create the solution.
help us help you!
if you post consumable data, we can 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: Maint Plan Fails :-(
hada for me, the maintenance plan is outdated and not really good for production; it's fine for shops with no DBA, but I would strongly recommend replaicng it with 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: What a weird case in SQL 2012 - Need Help!
just a shot in the dark here, but this specific error:
Sintaxis incorrecta cerca de 'Begi'.
to me, that implies that a string, say a VARCHAR(50), had a command in it longer...
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: Drop Database x Sql Server Log
it's an issue of scope;
the error log is targeted for things that affect the server itself; stops and starts, hardware errors,dropped connections, etc all appear there.
From a SQL standpoint,...
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: change datasource of server in [sys].[servers]
i believe sp_addserver is used internally when you add a linked server.
having just replaced a server recently, this tidbit might be of some help.
we create a machine named APP-TEMP 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: SP redundant call
that's still a logical decision; from a static code point of vew, you could check if any procedure had a cursor: that would imply that it is calling some code...
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: using sp_MSforeachdb that will include DB name in the output
this query would be an order of magnitude faster (at least!) for getting row counts per table.
something like this is what you'd wnat to wrap with sp_msForEachdb:
...
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 - 2,356 through 2,370 (of 13,460 total)