madlan

Hi, I'm trying to get some progress feedback from the following (Restore DB using SMO): [CODE]Sub DoRestore() Dim svr As Server = New Server("Server\SQL2008") Dim res As Restore = New Restore() res.Devices.AddDevice("C:\MyDB.bak", DeviceType.File) res.Database = "MyDB" res.RelocateFiles.Add(New RelocateFile("MyDB_Data", "C:\MyDB.mdf")) res.RelocateFiles.Add(New RelocateFile("MyDB_Log", "C:\MyDB.ldf")) res.PercentCompleteNotification = 1 AddHandler res.PercentComplete, AddressOf ProgressEventHandler res.SqlRestoreAsync(svr) …

Hi, I'm trying to create multiple instances of a child form. This form has an event that feeds a string variable back to the parent so I'm declaring it with WithEvents which is declared outside of the Sub - meaning multiple clicks will not open multiple forms. Any idea on …

I'm writing a small search tool that searches a SQL Server database using Full Text Indexing. I have two text boxes with four radio buttons between (NEAR, OR, AND, AND NOT) Ex. CONTAINSTABLE(jobs, *, ‘computer NEAR California’) This works fine but if I start adding more text boxes\radio buttons (As …

Hi all, I'm trying to display the total extraction progress of a zip file as below. This gives me the total file size of all uncompressed files in the zip: [CODE] For Each backup In zip TotalSize = backup.UncompressedSize + TotalSize Next[/CODE] I'm then using this to get the current …

I'm trying to implement a used disk space "Progress Bar" on a form similar to the Computer view in Vista\Windows 7. The closest I've come is the progress bar but this is rather restricted for example the colour cannot be changed. Has anyone found an alternative?

Is there a method for checking which roles a user has in SQL using SMO? I can add a role via: [CODE]user.AddToRole("Administrators")[/CODE] But cannot see an obvious method to progmatically list them.

Hi, I'm trying to populate a tooltip with a list of users connected to a database when hovering over an row in a ListView. I'm using sysprocesses to show a list of databases and the connections, how do I tie this together? [CODE]select loginame, hostname, blocked, db_name(dbid) from master..sysprocesses where …