Viewing 15 posts - 9,931 through 9,945 (of 13,469 total)
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...
February 26, 2010 at 8:36 am
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...
February 25, 2010 at 9:49 am
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"
February 25, 2010 at 9:44 am
amalanto (2/25/2010)
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...
February 25, 2010 at 7:21 am
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...
February 25, 2010 at 6:19 am
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,...
February 24, 2010 at 6:21 pm
old post Joie; someone must have run a search and replied to the thread today; i last posted on this thread July of 2009;
February 24, 2010 at 6:15 pm
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...
February 24, 2010 at 11:16 am
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...
February 24, 2010 at 10:13 am
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...
February 24, 2010 at 9:00 am
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...
February 24, 2010 at 8:25 am
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...
February 23, 2010 at 12:03 pm
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...
February 23, 2010 at 10:53 am
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...
February 23, 2010 at 9:07 am
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...
February 23, 2010 at 8:55 am
Viewing 15 posts - 9,931 through 9,945 (of 13,469 total)