Forum Replies Created
Viewing 15 posts - 1,006 through 1,020 (of 13,460 total)
-
RE: How can i give Grant permission for synonyms from another database in same server.
i think synonyms don't magically solve cross database chaining.
if User [Bob] has access to [db1], but a synonym in there points to [db2], you need to add [bob] 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: Log Shipping Copy Job Not working as on time which specified
I like the direction Joie Andrews was going;
look at the job history, andn see how long it takes.(the duration column)
if you set it for every 15 minutes, but it takes...
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: 2014 DB size estimation
kruezer had it right; without data and substantially more information, it's just a guess.
if i said 700 gig is required, and kruezer said 80 gig , who has the better...
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: Keeping the server lists in SSMS
SQL-DBA-01 (5/18/2016)
if servers are connected via "registered server" list, does it mean that a session will away be active using my account?Nope, John Mitchell is right; Registered Servers or Central...
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: Linked Server
forget about hiding the linked server...just make sure only specific users are mapped to use credentials that are valid on the linked server, so everyone ELSE is "not be made",
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: Totals question
becuase you want the total inline with details, you need your same data twice...once grouped by TransacitonId, and the original data.
here's your data as an example: the CTE at 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: Executing Exe in C# using SSIS Execute Process Task
since you compiled to an executable, you need to process the command line arguments in the c# app; did you configure it to do that yet?
what i'm thinking is 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! -
RE: Architecture doubt
celia.moreno (5/18/2016)
Indexes are not an option, because these 700K transaction are about 600K inserts and 100K deletes.It is on our own server.
you should still review the indexes.
a classic...
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 avoid multiple if else in sql server
not sure what you are using the results for, but with so many values, i'd consider creatign a table with the permutations of the parameters you are filtering for.
maybe something...
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: Windows 10 - Visual Studio and associated apps
etl2016 (5/18/2016)
Hi,Am new to MS environment, coming from a diff programming background.
I am setting up my home computer for a collection of MS development tools. Could you please let...
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 server 2008 r2 jobs history
if you right click on SQL server Agent, and choose properties, what are the values you see here?
for me, with more than 60 jobs, some of them log backups ever...
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 1100+ DBs from Prod to QA
Sean Lange (5/17/2016)
Chitown (5/17/2016)
All, I need to refresh 1100+ DBs from Prod to QA. Is there any easy to accomplish this task?You will become familiar with both the backup 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: The SQL Saturday Thread
In my neck of the woods in South Florida, On Jun 18, 2016 I'll be at the SQLSaturday #524 - South Florida 2016
This event is ridiculously close to my house,...
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 giving Stored Procedure Not found when executed through a Web Service
I've seen this before due to connection pooling where the database context becomes the default database, instead of the one in the connection string;
ie the connection to the database...
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: auto script for auto-run to change sql login from British English to English language setting
interesting issue datsun; here's how i would do it.
the detection for me would simply be to query sys.server_principals:
select 'EXEC sp_defaultlanguage @loginame=''' + name + ''',@language=''us_english''',*
from sys.server_principals
where type_desc in('SQL_LOGIN','WINDOWS_LOGIN','WINDOWS_GROUP')...
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,006 through 1,020 (of 13,460 total)