Reminds me of the Monty Python "Is your name not Bruce" skit, where everyone was named Bruce, and they renamed newcomers to avoid confusion. Can't have a "Michael" running around...

easy to grab what you need; here's a better example:

select

parsename(convert(varchar,serverproperty ('productversion')),4) As T4,

parsename(convert(varchar,serverproperty ('productversion')),3) As T3,

parsename(convert(varchar,serverproperty ('productversion')),2) As T2,

parsename(convert(varchar,serverproperty ('productversion')),1) As...

i would use the PARSENAME function to return the 8/9/10:

select serverproperty ('productversion') --9.00.4035.00

select parsename(convert(varchar,serverproperty ('productversion')),4) --"9"

amalanto (2/25/2010)

---

Thank you sir.

Right now We have achieved by calling UDF.I want to know whether is it poassible through stored procedure.

Create Function dbo.Result(@TranId int)

Returns @t Table(@col1 varchar(10),@col2 Datetime)

Begin

Insert into...

amalanto in that case you have to create a table which will capture the results inside the stored procedure; so you need to know the structure and datatypes returned;something like...

i don't believe you can; the whole purpose of encryption is to hide the data....if the data was encrypted, but exposed as unencrypted in a view, it defeats the purpose,...

old post Joie; someone must have run a search and replied to the thread today; i last posted on this thread July of 2009;

i've had this happen to me too.

if you change your screen resolution to something smaller than it is currently(ie 800x600 if you are running 1024 x or higher), windows will...

this seems to be the same issue;

http://dis4ea.blogspot.com/2006/04/blank-message-box-when-starting-sql.html

looks like repairing the .NET 2.0 framework will fix the issue.

that post implied installing the 1.1 framework AFTER the 2.0 was already installed breaks...

TKE402 did you get a linked server to work yet? I've played with SQLite a little bit now; I've used this .NET provider for SQLite[/url] in VS 2005/2008 with no...

thank you Jayant, I'm glad i could point you in the right direction with your project.

feedback like yours is exactly why I like to help here; knowing I got to...

Here's what I always do, it might help you out as well.

I create a new regular user in AD or on the local machine called SQLAdmin. (ie yourdomain\SQLAdmin)

i make that...

replace your static column "Holidays with the calculation included in my example,a dn you get the results you wanted, without the whole update of my db every five seconds:

Create Table...

yeah this is a very common issue; pretty sure the issue is permission to get to the share; especially with the error access denied.

change the login used to run the...

pretty sure the issue is this:

\\<servername>\medlog\sql_apps\afmsql\daasc_reb\txt\work_reb_ftp1.txt

when you jump to xp_cmdshell, it doesn't matter what YOUR credentials are; sql server uses the credentials that is running the sql service, which...