Forum Replies Created
Viewing 15 posts - 1,561 through 1,575 (of 13,460 total)
-
RE: Hiding the security folder from contractors using SMSS
you are worried about something you don't need to worry about.
simply make sure they are not sysadmins.
if you create a user for your contractor, the ONLY user they can see...
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: Deny Alter and Deny Drop permissions on ONLY Stored Procedures
i'd be interested to know why, of course; is it because the username and password are passed around to developers? are you having trouble with people changing procs? are 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: Linked server
Janda Nel (8/19/2015)
good day .we have a development environment with linked servers,which worked well.We had to rename the server names for reasons.Now in the one server the linked server appear...
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: Backup SQL Express R2
you can use Windows Scheduled Tasks to create regular backups for SQL Express.
it's a scripted solution, typically with a bat file that calls sqlcmd.
google points me to a lot of...
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: DateSerial() Equivalent?
i found this user defined function that does the same thing:
http://www.experts-exchange.com/articles/670/DateSerial-Function-for-Microsoft-SQL-Server.html
SELECT dbo.DateSerial(Year(getdate()),6,30)
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 ADO.NET Source SQL command to reference a list dynamically
latingntlman (8/18/2015)
I apologize but I forgot to mention in my reply that the Teradata connection does not communicate with SQL tables, so if I join the staging table w/the customer...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 ADO.NET Source SQL command to reference a list dynamically
i do something like that, where truncate and insert a bunch of ID's from an AS400 connection, which then gets stuffed into a staging table on my Source SQL Server.
then...
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 login succeed many times in log
also, think about any items you might have installed, whether running in the background or as a service, that are running under your credentials, maybe something like RedGate lighthouse ,...
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: Where can I download a Thesaurus file?
lyleholc (8/17/2015)
Hi,I tried to download the mthesaurs at the link provided, but got error file not found or unavailable. Is it possible you could provide a link to me?
Thank...
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: Licensing for SSDT - With Visual Studio 2012
both SSDT and SSDT-BI are both free add ins. they add the templates related to using SQL server database projects (SSDT) and SSIS/SSAS projects (SSDT-BI)
i believe there is a flavor...
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 from a compressed backup (data not compressed) to compress the data at restore time
no, sorry.
if the database was 150 gig at backup time, you need 150 gig of disk space to restore it, regardless of the size of the *.bak file itself.
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: SSIS 2008 R2 - Failed Login but correct credentails
i believe if you set the owner of the job as your AD account, it would work.
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: SSIS 2008 R2 - Failed Login but correct credentails
taybre (8/17/2015)
GilaMonster (8/17/2015)
Look in the SQL error log (the instance you're trying to connect to). What's the full login failure message from the error log?I've just checked the error log...
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: Select Records based on Year
you want to leave the column alone, without functions or conversions, so you can use any existing indexes.
instead, generate the dates the date values should be in between:
DECLARE @Date datetime...
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: dates out-of-range value
don't convert dates to strings! the where statement you posted ends up causing a table scan, as it converts every date to a string, which in turn gets compared 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!
Viewing 15 posts - 1,561 through 1,575 (of 13,460 total)