Forum Replies Created
Viewing 15 posts - 3,406 through 3,420 (of 13,459 total)
-
RE: SQL Server Corporate Standards - Automated Compliance Checking
SQLCop does some code valdiation, along with other things it tests for; not sure if it is customizable o check for specific things like comments
http://sqlcop.lessthandot.com/detectedissues.php
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: Search Code in multiple Views
OK I stopped dragging my feet, and broke down and downloaded Redgate's SQL Search;
I admit it, i already see it's a great tool; very nice. Much Quicker and easier...
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: Universal driver for database for visual studio
it's a lot of work;
you probably want to search for "Data Access layer", which is what will sit between your application and the data below it;
it abtracts the implementation...
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: AD group has dbowner access to DB. How can I stop users from accessing from outside the application.
from the TSQL side, you could create a logon trigger that checks the application name and the login name both.
you could make sure the login is using a specific application...
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: Read mail using SQL Server 2008 r2
i should have mentioned to google for a SQL Server CLR+read email, you might have some luck finding something that already exists.
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: Read mail using SQL Server 2008 r2
UmaShankar Patel (5/22/2013)
Hi,I have configured SQL Server database mail.
Now i want to read mail of ID that i have configured in SQL Server 2008 r2 database mail.
is it possible?
How?
not directly,...
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: Trigger referring twice to a table doesn't work properly
you must not be pasting the whole code;
nowhere do i see the variable @dt defined, let alone set to a date/datetime value.
it doesn't pass basic syntax checking because of 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: Post Installation Changes (data directories) with SQL Server 2012
also, i you can go to the facets for the server, and modify the same paths opc.three posted, but via the GUI 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: BCP Utility to output contents into CSV
bikram.g.it (5/21/2013)
I thought about that and I had checked the permission. I would have thought if permission was an issue then the result would be same when running from SSMS...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 an efficient way to do dynamic sorting within SQL ?
well, because your query is a catch-all-query, it's going to be a table scan, which will not be efficient at all; read a little bit more hear:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
you could probably address...
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: Moving everything on an SQL instance to new hardware
Jeff I've only file copied system files a couple of times when building backup machines; i know that the new server has to be the exact same version, ie 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: syntax difference between create index and create clustered index
they are both the same, the keyword NONCLUSTERED is optional and is the default value when you create a new index.
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 much faster is bulk insert?
Google Translate (5/21/2013)
Well, after reading it all, try to follow the best techniques on data replication scheme from a DB2 database to another SQL Server 2012, then I will tell...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: DB restore file must not be in C:\Temp
most likely permissions, as previously identified, but maybe i can help you find out the specifics.
if i right click on my temp folder, and go to the security tab, i...
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: Subscription Emailing report when it shouldnt....or when its not desired
dndaughtery (5/21/2013)
I have a datadriven subscription that uses a stored procedure.The code is below:
declare @ReturnValue int
exec @ReturnValue = s003pSRC.sp_Par_Rate_Compare_Report_Subscription_Condition
select @ReturnValue ReturnValue
I have run the sp in ssms 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!
Viewing 15 posts - 3,406 through 3,420 (of 13,459 total)