.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SQL 2008 and above - xp_cmdshell replacement ?

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server
 

Hello All !

"xp_cmdshell" is not a recommanded SQL command (security and so on) ... in SQL 2005 or >, but is there a simple command to do the same things with security with SQL 2008 or R2 or > ?

do I need to use SMO objects or include Powershell command in my queries ?

 


Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2


View Complete Post


More Related Resource Links

what is the ntwdblib.dll replacement in sql 2008? or where to install it

  

the vendor needs ntwdblib be installed to connect a sql 2008 sp1 server, holding database with 80 compatible level.

I din't find this library in sql 2008, searched and found it is deprecated, my question is where to find this dll? and what folder on the new machine with sql 2008 client installed should I paste into?

thanks

 


Replacement of iSQL for SQL 2008 Express?

  
Hi,

I know it is a bald movement to ask it here but I give it a try:
I used iSQL for managing databases on MS SQL 2000 (MSDE). and it has a pretty nice UI (much like Management Studio) and has a decent size of 1.5 MB. Is there an upgraded version of it for SQL 2008 Express or I need to download the 160MB(!) version of SSMSE for the 60MB Server ?
Andris

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Sql Server 2008 Tutorials

  
This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

  
Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008

  

I am having problems with a user control. I want my solution to have a separate project for holding my user controls.


The main project can get a reference to this user control project and can import this user control dll into my main project. 


Thanks in advance,

Dheeraj Mittal

dhemittal@gmail.com


Visual Web Developer 2008

  

I'm getting th error "unable to connect to the asp.net development server 2008"

It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.

Thanks,

Regards


Visual Studio 2008 Memory problems

  

My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p

  

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project

 

my current project references

 

 

 

i have a very annoying iis problem

iis server stops working until app pool is recycled

 

i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem

 


Replacement options for Membership

  

Hi everyone,
     I tried to use Microsoft's Membership option for signing up new users and authenticating them on subsequent pages, but it has not worked very well. The biggest issue has been with the REMEMBER ME function. With this checked, I am randomly logged out in the middle of some functions and some pages always show me as not authenticated, while others properly show me as authenticated. I built a site based on VB.
I was wondering what other people are using ro register users and monitor authentication and also if anyone has had better experiences with other solutions. 

Hi everyone,

     I tried to use Microsoft's Membership option for signing up new users and authenticating them on subsequent pages, but it has not worked very well. The biggest issue has been with the REMEMBER ME function. With this checked, I am randomly logged out in the middle of some functions and some pages always show me as not authenti

Error upgrading SQL Server 2008

  

i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Business Intelligence Reports Project in Visual studio 2008 ?

  

Hi, 

I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..


Installing both VS Pro 2008 and VWD2008

  

I work at an educational institution and in our computing labs we have Visual Studio Professional 2008 installed already. One of our academics has requested me to install Visual Web Developer 2008 Express Edition as they think it's easier for their beginner students to learn, but I've noticed it wants to install it in the same folder as our Visual Studio Professional install.

Can both be installed without the limited VWD interfering with the Professional version?


SQL 2008 timeout

  

I am recently getting a timeout exception when executing this method. This table stores images and it might be due to the size of the table. I have no idea! Help!

 

 Public Sub StoreFile(ByVal fileId As Integer, ByVal upload As Stream, ByVal connection As SqlConnection)
        Try
            Dim bufferLen As Integer = 8040
            Dim br As BinaryReader = New BinaryReader(upload)
            Dim chunk As Byte()
            chunk = br.ReadBytes(bufferLen)

            Dim cmd As SqlCommand = _
            New SqlCommand("UPDATE tblContactDocuments SET ContractDocument=@Buffer WHERE AutoID=@FileId", _
                           connection)
            cmd.CommandTimeout = 30
            cmd.Parameters.AddWithValue("@FileId", fileId)
            cmd.Parameters.Add("@Buffer", SqlDbType.VarBinary, bufferLen).Value = chunk
            cmd.ExecuteNonQuery()

            Dim cmdAppend = New SqlCommand("UPDATE tblContactDocuments SET CONTRACTDOCUMENT.WRITE(@Buffer, NULL, 0) WHERE AutoID=@FileId", _
                                               connection)
            cmdAppend.Parameters.AddWithValue("@FileId", fileId)
            cmdAppend.Parameters.Add("@Buffer", SqlDbType.VarBinary, bufferLen)
            chunk = br.ReadBytes(bufferLen)

            While (c

sql server 2008 adventureworks database

  

dear Friends


For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 


And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	


Please help me to overcome this issue and let me know where can I download that database too.


Thanking you

happy Coding


PostGreSQL to sql server 2008?

  

Hi,

I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?

Regards,

ap. 


Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend