App-V application license requirements
So if the receiver of the App-V application which has an embedded SQL Server in it already has a liscense to access an SQL Server then ther are no new liscenses required. If that is not the case then the receiver of the App-V application will need to purcahse what? This question is from the...
View Answer
| Sep 14 2009 1:47 PM GMT
Microsoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
So if the receiver of the App-V application which has an embedded SQL Server in it already has a liscense to access an SQL Server then ther are no new liscenses required. If that is not the case then the receiver of the App-V application will need to purcahse what? This question is from the...
View Answer
| Sep 14 2009 1:47 PM GMTMicrosoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
10345 pts.
Applying snapshot on Subscriber - SQL SERVER 2005
hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part. When the snapshot is created and...
hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part. When the snapshot is created and...
What are the licensing requirements associated with App-V?
What are the licensing requirements associated with App-V? That is if the application being virtualized uses SQL Server and it is part of the virtual application does the user of the App-V package require a full SQL Server license? This question is from the Microsoft Virtualization Chat held on...
View Answer
| Sep 11 2009 5:25 PM GMT
Microsoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
What are the licensing requirements associated with App-V? That is if the application being virtualized uses SQL Server and it is part of the virtual application does the user of the App-V package require a full SQL Server license? This question is from the Microsoft Virtualization Chat held on...
View Answer
| Sep 11 2009 5:25 PM GMTMicrosoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
Controlling tempdb Growth
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...
can one use App-V to install SQL Server as part of a virtualized application?
can one use App-V to install SQL Server as part of a virtualized application? This question is from the Microsoft Virtualization Chat held on August 27th.
View Answer
| Sep 11 2009 1:55 PM GMT
Microsoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
can one use App-V to install SQL Server as part of a virtualized application? This question is from the Microsoft Virtualization Chat held on August 27th.
View Answer
| Sep 11 2009 1:55 PM GMTMicrosoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
How can one 'v-app' an application that uses a db like SQL 2008 express?
How can one 'v-app' an application that uses a db like SQL 2008 express? This question is from the Microsoft Virtualization Chat held on August 27th.
View Answer
| Sep 10 2009 9:23 PM GMT
Microsoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
How can one 'v-app' an application that uses a db like SQL 2008 express? This question is from the Microsoft Virtualization Chat held on August 27th.
View Answer
| Sep 10 2009 9:23 PM GMTMicrosoft virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27
Data model for Custom fields and Custom forms.
Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta...
Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta...
Community Update: The IT Blog Top 10 for Sept. 10, 2009
As part of a new feature on the Community Blog, each week we'll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an e-mail at...
As part of a new feature on the Community Blog, each week we'll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an e-mail at...
Error copying indexes in DTS package
I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a...
I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a...
Why should I use SSAS for Predictive Analytics?
We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us? Software/Hardware used: SSAS 2008, Microsoft SQl Server 2008, Windows Server 2008
We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us? Software/Hardware used: SSAS 2008, Microsoft SQl Server 2008, Windows Server 2008
SQL server 2000 increase database auto-grow
Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is ...
Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is ...
SQL convert numeric to date format
How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between month(current date and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert my 8...
How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between month(current date and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert my 8...
How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control. This is what I need to do: I need to retrieve the...
After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control. This is what I need to do: I need to retrieve the...
SQL dynamic date calc.
How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be...
How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be...
On Error Resume Next SQL Server 2005
Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. thanks in advance.
Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. thanks in advance.
SQL select loop list?
Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...
Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...
Aren't correlation IDs ok in MSSQL for an UPDATE statement?
I'm getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I Software/Hardware used: MSSQL
I'm getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I Software/Hardware used: MSSQL
Advantages and disadvantages of MySQL 5.0
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??
Is share point an alternative / more than SQL Server?
I m poor in using MOSS Microsoft Office Share Point. I have web application in ASP using IIS and SQL Server 2005. Now if I have no licence for SQL Server 2005 can I use MOSS as an alternative for SQL Server 2005? Is it possible to create / attach data base in MOSS / MOSS related SQL...
I m poor in using MOSS Microsoft Office Share Point. I have web application in ASP using IIS and SQL Server 2005. Now if I have no licence for SQL Server 2005 can I use MOSS as an alternative for SQL Server 2005? Is it possible to create / attach data base in MOSS / MOSS related SQL...
CLR Assembly in MS SQL 2008
I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?
I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?
