Forum Replies Created
Viewing 15 posts - 3,406 through 3,420 (of 13,469 total)
-
RE: Creating a Custom Function (Scalar)
i believe functions that are not CLR functions must be prefaced by the schema:
SELECT
Address1,
Address2,
dbo.FNCNOTAVAILABLEDISPLAY(Address3)
FROM Customers
-
RE: [sys].[dm_os_volume_stats]
this link says the function is part of 2008R2 SP1 or later:
It is available in SQL 2008 R2 with SP1 or later. http://msdn.microsoft.com/en-us/library/hh223223(SQL.105).aspx
-
RE: [sys].[dm_os_volume_stats]
if you run the command in the master database on the server that seems to fail, does it work?
CROSS APPLY for a function will fail syntax if the database compatibility...
-
RE: Super script
saving rtf text, or saving it inside a document(like word) which supports font formatting are the only other ways i can think of.
-
RE: Does SQLSERVER2008 offer Object level recovery
AmarettoSlim (5/22/2013)
Resurrecting this thread with a question I have...Can someone explain why SQL Server doesn't support object level recovery in a native manner?
How do 3rd party vendors make this possible?
I'm...
-
RE: Super script
are you storing html? the sup tag is for superscript, for example, this is a valid html :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<body>
some text <sup>SM</sup>
</body>
</html>
-
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
-
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...
-
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...
-
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...
-
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.
-
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,...
-
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...
-
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:
-
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...
Viewing 15 posts - 3,406 through 3,420 (of 13,469 total)