Why Not Using The Same Develop Model As Normal .NET Develop?

Aug 27, 2007

Now, the developement in SqlServer Clr is obviously different from the develop in normal programs. there are many limitation in Clr develop, and it take many work to use dll alread exsits in Clr develop.

I do know that some limitation is reasonable, BUT much more limitation should be removed.

For example, now in order to use enum that exists in old dll in sqlServer, we have to create a new project and write many similar class to wrap the old enums, it's very troublesomely and slow!


so pls make the develop model consistent as possible.

View 3 Replies


ADVERTISEMENT

What Do I Need To Develop SQL 7.0 Offline?

Feb 16, 2001

I have to design, load and write scripts for a remotely hosted SQL 7.0 Server.
My desktop computers are both Windows 98. What do I need to develop and publish databases from my desktop to the remote host? I have always had the luxury of having direct access to the SQL Server and cannot find any conclusive guidance at Microsoft's site.
Thanks so much for your help.

View 2 Replies View Related

SQL CE Develop/Deploy

Jul 26, 2007

Hello all,
I've looked through this forum and haven't found an answer to my question, but I'll make this short and sweet, as I know your time is valuable.
I've taken a MS Access database and turned it into an SQL database for our server, it works. However, I want to make an identical database (to distribute to 30-40 employees) in SQL CE, so that employees can work on their laptops offline and sync their data to the main database when they return to the office. Am I going in the right direction, or is there a better way to do this?
I won't bother you for a step-by-step, but any and all info/guidance you could provide would be of great use to me.
Thanks for your time!!!

CG

View 3 Replies View Related

How To Develop Cross-Tab Like Query

Sep 7, 1999

I have a table which stores the following data:

Col1 Col2
A Apple
A Orange
B Pear
C Banana
C Tomato
C Apple
C Pear

I want to display it in the following manner using a SELECT statement.
Col1 Col2 Col3 Col4 Col5
A Apple Orange
B Pear
C Banana Tomato Apple Pear

Can anyone help me figure out this SQL Statement.

Thanks,
Tim

View 2 Replies View Related

Develop Authorization Matrix

Sep 16, 2015

I am trying to develope a authorization matrix for cpmpany of 75 employees, with different roles and permissions for roles to some applications like CRM , diiffrent folders,databases etc. I tried to find some informaton about this auhtorizaion matrix.

View 0 Replies View Related

How To Develop Sproc With A Sql Tool

Mar 12, 2008

Hello,

I heard from someone that sql procedure can be created by some sql server tool. So if i am using a sql 2005 or 2000 , how i can create a custom stored procedure. ?

thanks,

View 1 Replies View Related

How Do I Develop Project Like SQL Compare 6?

Nov 1, 2007



Hi,
This is my first message in this forum. I am a University Student. I have to develop project that compares two databases objects then finds differences between two databases. Then project must synchronizes two databases. This project is similar with Red Gates's SQL Compare 6. I couldn't find any idea to start developing this projet. Is there anybody that has any idea?

View 6 Replies View Related

On A Lighter Note - What Equipment Do You Use To Develop?

Mar 27, 2007

This isn't a performance type of question, or whose CPU is bigger, but I'm more interested in knowing what people use out there as far as monitor setups go.

The root of the question stems from working in large package where there are many components laid out on the work flow. What do you use to work with large layouts? I constantly find it troubling to view enough of my package and am always zooming out to see more of the package. However, when doing that, the text becomes unreadable, of course.

I currently use a dual-monitor setup using my laptop and a LCD flat screen.

Resolutions on the laptop is 1920 x 1200 and the LCD monitor is 1280 x 1024. This helps to keep windows and output screens on one monitor while keeping the work flow on the other. Even still, I wish I had more screen real estate.

So, what say you?

View 6 Replies View Related

Managing Live And Develop Database

Dec 7, 2006

Hello,

I haven written a Windows program in Visual Studio 2005. This program stores data in and retrieves data from a SQL Express database. The customer is starting to use the program and filling the database with data. However the program is still under construction (new functionality will be added) and so is the database (new tables, views etc. will be added). 

Of course I could send the customer the new database, but than all data already entered will be lost.....

I'm thinking about using the SQL Management Studio Express and VS2005 to connect remotely to the database (a VPN connection is availabe) but worry about performance issues.... Or should I use some kind of replication / synchronization and how, because this is new to me. 

What is the best way to solve this 'problem' ?

 

 

 

 

 

 

 

 

 

 

 

View 5 Replies View Related

How Hard It Is To Develop On Express And Deploy On 2000?

Jun 2, 2006

Hey everyone,First off, sorry if this has been asked and answered before--I've tried searching the forums but may have just not used the right criteria.  Anyways, I'm new to .net and all that stuff, and I was wondering if there were any differences (code-wise) between developing on 2005 Express and running on SQL 2000.  I know there would be variations in the connection string, but I wasn't sure about anything else--specifically if they both use the sql provider thingy (I forget the name of it, since I don't have my book in front of me).  I don't expect there to be many differences, but I wanted to check before I got too deep into coding.Thanks in advance.

View 1 Replies View Related

First Time Installation Of SQL Server 2005 Develop

Oct 13, 2007

Just placed the SQL Server 2005 - Developer Edition into my Drive...

I get prompted with the following options..
This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin
x86-based operating systems
x64-based operating systems
Itanuim-based operating systems
I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...
I will be installing it on my PC... i
Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2
My local Hard Drive remaining capacity is 12.6GB
External Hard Drive remaining capacity is 11.0GB
Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video....
Thanks for your help

View 14 Replies View Related

How To Develop Today Screen Plug In For WM5 Pocket PC

Apr 17, 2007

Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.

View 1 Replies View Related

Develop Multiusers Applications With SQL Server Express

Feb 3, 2006

Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?

View 3 Replies View Related

How To Start Develop Database Applicaton On Pocket Pc ?

Jul 27, 2006

i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)

- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?

thank you

View 1 Replies View Related

Is Anyone Using C# And The SSIS Objects To Develop/Modify Packages?

Mar 26, 2006

Anyone out there developing or modifying packages w/ C# and the SSIS objects that I can compare notes with?

Thanks!

View 18 Replies View Related

Develop Report Using 2008 And Deploy On 2005..........?

Jan 10, 2008

Hi,

just wanted to know,
Is it possible to deploy a report develped by 2008 on to ssrs 2005 server, if so does it work fine.....?

View 3 Replies View Related

Is It Possible To Develop A Custom Report Item Other Than Image Type

Sep 10, 2007

I have developed a renderer that renders the xml to paint a rectangle with textboxes in all the right places based on the data retrieved off the database. When i render the a complete report to the reportviewer i have no problem.

I need however to render the rectangle into a custom report item for reusability and different scenarios. This just seem to be impossible since it seems like I cant use anything other than an imagemap to render custom report items. Is this true?

To make sure you understand....in other words....

Is there a way to develop a Microsoft.ReportingServices.ReportRendering.IRenderingExtension that renders the required xml like rectangles/textboxes etc. and then migrate this to a custom toolbox item. It just seems like this should be a very easy thing to do and something regularly needed. For example when you want to use textboxes in certain positions within a rectangle to draw a organisational chart.

View 3 Replies View Related

What SQL Server Version Should I Use To Develop On And Install On A Client Pc For A Winforms App?

Nov 30, 2006

Hi all,

I've finally received my first official assignment using vb.net and SQL Server.

I have been developing / learning with both on the express editions.

I've also just run into some issues trying to access a SQL Server 2005 Express .mdf thru
SQL Server 2005 Pro.

We just couldn't get it to open. Connecting or Attaching etc...

We had to install SQL Server Express on the other PC to get it to open the SQL Server 2005 Express .mdf.

---

Now that I am ready to develop in ernest, I would like to setup my own controlled development environment.

Our target is a winforms application with a SQL Server 2005 Database for WinXP or Vista.

I'm ready to purchase Visual Studio 2005 Pro once I figure out the best development environment and SQL Server Version.

Specifically, once I've developed my winforms app, what issues do I need to consider to install a SQL Server 2005 database server / engine on a client / users machine?

Can I use the SQL Server 2005 Express?
Or perhaps there is an MSDE equivilant for 2005?

I can't seem to find any info regarding installation procedures for SQL Server in this regard.
(Perhaps its because I'm using the express editions?)

Any positive contructive help would be greatly appreciated.

Thanks,

Barry G. Sumpter

View 1 Replies View Related

Does 64-bit Version Of SQLServer Compact In Microsoft's Develop Schedule?

Nov 11, 2007



I am looking forward to a native 64-bit file-based database solution on Microsoft Windows platform. And I don't know why Microsoft didn't release the native 64-bit solution for JET engine (MDB file).

So, before I using this light-weight and file-based version of SQL Server, I will like to ask the question that the 64-bit version has been put into develop schedule?

Thanks.
Alva

View 1 Replies View Related

Reporting Services :: Develop SSRS Report Based On Grouping Of Certain Columns

Sep 1, 2015

I want to develop a ssrs report which is grouped by month?

View 4 Replies View Related

Data Warehousing :: How To Decide Whether It Is Required To Develop Operational And Analytical Reports

Jul 15, 2015

I have received some reports and I have been asked to decide whether these reports can be developed as an operational report or Analytical Reports.

Basically I wanted to understand what points needs to be considered while deciding whether I should go for Analytical reporting (Cubes) or Operation Reporting.

View 2 Replies View Related

What Version Of SQL Server To Choose In Order To Develop SSAS, SSIS And SSRS 2005 Projects On Xpsp2?

Oct 27, 2007



Good day community. I have a question about SQL Server 2005 Anywhere edition which i currently installed on my desktop. Does it fit my needs which stated on the subject? If no, what should i select for my projects?

View 1 Replies View Related

Report Model Deployment : The Model ID Of The Submitted Model Must Match That Of The

Dec 5, 2005

Running 2005 Beta 3 Refresh.  When I first deploy, it works fine. Subsequent deployments yield the following error:

View 9 Replies View Related

Power Pivot :: Building A Model Based On Multinational Model With Different Languages?

Oct 19, 2015

I need to develop a language specific dwh, meaning that descriptions of products are available from a SAP system in multiple languages. English is the most important language and that is the standard. But, there are also requirements of countries that wants productdescriptions in their language. 

Productnr Productdesc Language
1            product       EN
1            produkt       DE

One option is to column the descriptions, but that is not very elegantly. I was thinking of using bridge tables to model this but you have to always select a language in a filter (I think)..

I'm thinking of a technical solution, such that when a user logs on, the language is determined and a view determines whether to pick a certain product table specific for a certain language. But then I don't have the opportunity to interchange the different language specific fields in a report (or in my case PowerPivot).

View 2 Replies View Related

Can We Pause Log Shipping, Bring Primary Db To Simple Recovery Model And Then Back To Full R Model?

Apr 25, 2008



We have the following scenario,

We have our Production server having database on which Few DTS packages execute every night. Most of them have Bulk Insert stored procedures running.

SO we have to set Recovery Model of the database to simple for that period of time, otherwise it will blow up our logs.

Is there any way we can set up log shipping between our production and standby server, but pause it for some time, set recovery model of primary db to simple, execute DTS Bulk Insert Jobs, Bring it Back to Full recovery Model AND finally bring back Log SHipping.

It it possible, if yes how can we achieve this.

If not what could be another DR solution in this scenario.

Thanks Much
Tejinder

View 6 Replies View Related

Is This Normal

Nov 23, 2005

Hi. Sorry if I am asking a stupid question since I am an absolutely beginnerin SQL Server. Here is the question . . .About 13 hours ago, I got my SQL Server 2000 to index a table which has 104million records. At first the CPU usage was high. But after an hour or two,the process has seemed dead and the Enterprise Manager has had no response.The CPU usuage dropped to zero and has been jumping between 0 to 5%. Theharddisk indicator has been blinking at a rate of roughly three times pertwo seconds.Is this normal? Has anyone got any idea how long the process would take? Ihave assigned 1.8GB of RAM to the SQL service and is currently taking upabout 1GB.

View 7 Replies View Related

Just The Most Normal Connexion

Dec 7, 2003

Impossible to connect to my mssql 2000 database

web.config connexion string >>>

<add key="DataSourceSql" value="Initial Catalog=angiras;Data Source=localhost;Uid=sa;Pwd=;" />

or

<add key="DataSourceSql" value="Initial Catalog=angiras;Data Source=localhost;" />

connexion code >>>

Private ConnexionSQL As SqlConnection

Public Sub OpenConnexionSQL()
ConnexionSQL = New SqlConnection(ConfigurationSettings.AppSettings("DataSourceSql").ToString)
ConnexionSQL.Open()
End Sub

when I try >>>

OpenConnexionSQL


I get an error


any idea ?

thank you

View 1 Replies View Related

Normal Forms

Feb 1, 2008

Hi guys, I've been thinking about this problem now for some time but somehow I don't know if my "solution" for it is right. I'd like to read your opinion.

There is a Capital table with Capital_Nr, Capital_Name, Capital_Population, Country_Nr and Country_Name as attributes.

I know the table is chaotic so I brought it to 3NF :

Capital table : Capital_Nr, Capital_Name, Capital_Population, Country_Nr(foreign key)

Country table : Country_Nr and Country_Name

Ok so I guess the table should be now in 3NF, but what intrigues me is in what NF the table originally was. I tried then to use Codd's definition of 2NF : "a 1NF table is in 2NF if and only if none of its non-prime attributes are functionally dependent on a part (proper subset) of a candidate key". In my opinion the original candidate keys could only be {Capital_Nr},{Country_Nr} and {Country_Name}, each one of them single, i.e. separate from each other. So, as there is no composite candidate key, I can affirm that the original table was in 2NF. Am I right ?

Thanks !

View 3 Replies View Related

Normal Disk IO

Apr 15, 2008

I am wondering what normal disk I/O should be.
i know it verys depending on use but im looking for an average.

here is an idea of what we have

there is about 10 centers doing replication to our primary server.
we have about 80 users connecting directoy to our primary server using MS Dynamics through CITRIX.
we have a few other apps use the database as well however i am fairly certin its Dynamics generating our disk IO
Hardware wise we have a powerful blade connected to a raid 5 SAN with 15000 rpm disks.
normaly the disk IO stays fairly low but every so often it goes crazy and im thinking it shouldn't

Below is a sample of our disk IO from perfmon over 2 minutes or so. as you can see everything looks ok untill 04/15/2008 10:12:49.470 when the Disk I/O % goes above 100%

"04/15/2008 10:12:23.470","2.8300181121159178"
"04/15/2008 10:12:24.470","0"
"04/15/2008 10:12:25.470","3.950025280161793"
"04/15/2008 10:12:26.470","0"
"04/15/2008 10:12:27.470","0"
"04/15/2008 10:12:28.470","5.9800382722449426"
"04/15/2008 10:12:29.470","7.7400495363170325"
"04/15/2008 10:12:30.470","3.4500220801413128"
"04/15/2008 10:12:31.470","0"
"04/15/2008 10:12:32.470","4.180026752171214"
"04/15/2008 10:12:33.470","3.8600247041581071"
"04/15/2008 10:12:34.470","0"
"04/15/2008 10:12:35.470","142.71091334984544"
"04/15/2008 10:12:36.470","0"
"04/15/2008 10:12:37.470","1.1500073600471041"
"04/15/2008 10:12:38.470","0.81000518403317789"
"04/15/2008 10:12:39.470","0"
"04/15/2008 10:12:40.470","2.1400136960876548"
"04/15/2008 10:12:41.470","10.230065472419025"
"04/15/2008 10:12:42.470","4.5800293121875981"
"04/15/2008 10:12:43.470","0"
"04/15/2008 10:12:44.470","0"
"04/15/2008 10:12:45.470","14.500092800593926"
"04/15/2008 10:12:46.470","6.730043072275663"
"04/15/2008 10:12:47.470","1.6300104320667652"
"04/15/2008 10:12:48.470","7.3500470403010585"
"04/15/2008 10:12:49.470","264.66169383484055"
"04/15/2008 10:12:50.470","324.18207476527851"
"04/15/2008 10:12:51.470","536.17343150996169"
"04/15/2008 10:12:52.470","270.31172999507197"
"04/15/2008 10:12:53.470","331.97212462159757"
"04/15/2008 10:12:54.470","333.84213658967417"
"04/15/2008 10:12:55.470","435.57278766584108"
"04/15/2008 10:12:56.470","442.31283080211716"
"04/15/2008 10:12:57.470","685.92438991609549"
"04/15/2008 10:12:58.470","295.1618890360898"
"04/15/2008 10:12:59.470","61.470393410517829"
"04/15/2008 10:13:00.470","56.360360706308519"
"04/15/2008 10:13:01.470","45.260289665853861"
"04/15/2008 10:13:02.470","224.58143732119885"
"04/15/2008 10:13:03.470","1022.0365410338626"
"04/15/2008 10:13:04.470","1114.6271336136551"
"04/15/2008 10:13:05.470","241.52154573789269"
"04/15/2008 10:13:06.470","506.79324347675828"
"04/15/2008 10:13:07.470","374.88239924735518"
"04/15/2008 10:13:08.470","359.5723012627281"
"04/15/2008 10:13:09.485","427.62119831413077"
"04/15/2008 10:13:10.485","400.15256097639025"
"04/15/2008 10:13:11.485","1076.2868882360847"
"04/15/2008 10:13:12.485","325.94208602935055"
"04/15/2008 10:13:13.485","449.36287592240592"
"04/15/2008 10:13:14.485","344.28220340610181"
"04/15/2008 10:13:15.485","569.57364527132972"
"04/15/2008 10:13:16.485","775.02496015974498"
"04/15/2008 10:13:17.485","729.54466908588222"
"04/15/2008 10:13:18.485","778.70498371189581"
"04/15/2008 10:13:19.485","1080.1269128122422"
"04/15/2008 10:13:20.485","754.56482921490704"
"04/15/2008 10:13:21.485","999.11639434492372"
"04/15/2008 10:13:22.485","701.36448873272786"
"04/15/2008 10:13:23.485","276.26176807531567"
"04/15/2008 10:13:24.485","252.13161364232732"
"04/15/2008 10:13:25.485","533.27341294984296"
"04/15/2008 10:13:26.485","759.54486108711092"
"04/15/2008 10:13:27.485","817.11522953746908"
"04/15/2008 10:13:28.485","129.41082822930068"
"04/15/2008 10:13:29.485","158.94101722251023"
"04/15/2008 10:13:30.485","160.55102752657618"
"04/15/2008 10:13:31.485","655.87419759486454"
"04/15/2008 10:13:32.485","444.49284475420637"
"04/15/2008 10:13:33.485","272.47174381916045"
"04/15/2008 10:13:34.485","94.730606275880163"
"04/15/2008 10:13:35.485","355.28227380655238"
"04/15/2008 10:13:36.485","898.29574909279427"
"04/15/2008 10:13:37.485","1309.3783800216322"
"04/15/2008 10:13:38.485","88.200564483612695"
"04/15/2008 10:13:39.485","1.2300078720503811"
"04/15/2008 10:13:40.485","4.9400316162023437"
"04/15/2008 10:13:41.485","217.90139456892524"
"04/15/2008 10:13:42.485","373.26238887928884"
"04/15/2008 10:13:43.485","73.760472067021226"
"04/15/2008 10:13:44.485","1.4100090240577541"
"04/15/2008 10:13:45.485","34.960223745431975"
"04/15/2008 10:13:46.485","15.990102336654955"
"04/15/2008 10:13:47.485","63.580406914604247"
"04/15/2008 10:13:48.485","26.560169985087906"
"04/15/2008 10:13:49.485","11.150071360456707"
"04/15/2008 10:13:50.485","15.250097600624644"
"04/15/2008 10:13:51.485","17.010108864696736"
"04/15/2008 10:13:52.485","12.210078144500125"
"04/15/2008 10:13:53.485","95.650612163917842"
"04/15/2008 10:13:54.485","38.740247937586801"
"04/15/2008 10:13:55.485","5.6000358402293777"
"04/15/2008 10:13:56.485","1.6600106240679942"
"04/15/2008 10:13:57.485","19.590125376802412"
"04/15/2008 10:13:58.485","2.8100179841150981"
"04/15/2008 10:13:59.485","631.48404149786563"
"04/15/2008 10:14:00.485","579.14370651972172"
"04/15/2008 10:14:01.485","1.0600067840434177"
"04/15/2008 10:14:02.485","15.870101568650039"
"04/15/2008 10:14:03.485","112.28071859659903"
"04/15/2008 10:14:04.485","15.660100224641438"
"04/15/2008 10:14:05.485","4.9800318722039822"
"04/15/2008 10:14:06.485","25.44016281704203"
"04/15/2008 10:14:07.485","16.130103232660691"
"04/15/2008 10:14:08.485","5.9300379522428939"
"04/15/2008 10:14:09.485","4.8400309761982481"
"04/15/2008 10:14:10.485","2.6400168961081349"
"04/15/2008 10:14:11.485","19.430124352795858"
"04/15/2008 10:14:12.485","42.55027232174286"
"04/15/2008 10:14:13.485","37.550240321538055"
"04/15/2008 10:14:14.485","1.210007744049562"
"04/15/2008 10:14:15.485","15.930101952652498"
"04/15/2008 10:14:16.485","20.550131520841735"
"04/15/2008 10:14:17.485","4.0900261761675267"
"04/15/2008 10:14:18.485","8.0100512643280908"
"04/15/2008 10:14:19.485","1.6000102400655365"
"04/15/2008 10:14:20.485","2.3300149120954372"
"04/15/2008 10:14:21.485","1.6200103680663558"
"04/15/2008 10:14:22.485","10.730068672439504"
"04/15/2008 10:14:23.485","4.4600285441826832"
"04/15/2008 10:14:24.485","9.0300577923698704"
"04/15/2008 10:14:25.485","0"
"04/15/2008 10:14:26.485","15.550099520636932"
"04/15/2008 10:14:27.485","2.970019008121652"
"04/15/2008 10:14:28.485","64.580413314645213"
"04/15/2008 10:14:29.485","71.850459842942996"
"04/15/2008 10:14:30.485","53.220340610179903"
"04/15/2008 10:14:31.485","32.620208769336124"
"04/15/2008 10:14:32.485","1.0000064000409603"
"04/15/2008 10:14:33.485","4.8400309761982481"
"04/15/2008 10:14:34.485","8.2700529283387425"
"04/15/2008 10:14:35.485","11.160071424457115"

View 1 Replies View Related

Normal Vs Surrogate/artificial Key?

Jun 10, 2008

 Hey All, I'm trying to decide what's the 'best' to use.  I've been designing and creating database for a while and have pretty much always used a surrogate key and not a normal one.  I've finally had some free time to start studying more so in my spare time and read up and come accross a lot of guides, articles and stories that tout that normal keys should be used whenever possible as they're a better identifier and that surrogate keys should only be used when there is not a readily available normal key.  Now perhaps I'd be open to accepting that but absolutely every database I come across tends to only use surrogate keys.  For example I'm doing an authentication system from scratch and am looking at the User table.  Now of course the user name has to be unique, should that be the primary key or should I have a seperate column with a guid or an incrementing int or the like as the primary key? I can certainly see that username could be used.  I can also see how it may be easier when looking through the data tables to identify who/what a table is refering to with a surrogate key.  However it still seems sort of sloppy, for lack of a better word, to me.  Where now I could have somebody's username (or any other piece of data used for this purpose) spread accross a lot of other tables.  And while writting this I just thought of the scenario that perhaps somebody needs their username changed, with this method now the ids need to be changed on all the related rows of all the other tables whereas with a surrogate key it wouldn't matter. Anyways I'm mostly looking for opinions on which way to go (not just with the user sample, but more in general).Thanks.

View 2 Replies View Related

Difference Bw SP And Normal Query

May 9, 2001

Hi all,

I've been running a long query which takes almost 39 seconds in Query Analyzer. After creating a Stored Procedure (with the same query) I expected to run it faster bcoz I heared that SP has a cache, and its a faster technique. But I didnt gain any performance improvments.

Can somebody clear my confusion, what I'm doing wrong.

Thanks!

View 1 Replies View Related

Normal User Backup

Jan 12, 2000

We have a payroll database that needs to be backed up just before completing the payroll for that period. I need to create a batch file that a normal user can run that will tell the database to back up and then tell the user when it is done so they can continue working. Is there an easy way to do this without giving the users special permissions? I don't want to give them backup op status. Any help would be appreciated.

View 4 Replies View Related

Not Normal Will Stored Procs Help

Jun 19, 2000

I will be taking over a database that has almost no pk's or relations(this is not my choice, but a vendors)
Management is looking at stored procs to improve performance, but I am wondering
if the db is in this state will there really be a gain. I am pushing for normalization
first, but if anybody has any ideas or opinions I would appreciate

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved