sql server 2000
i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.
Answer Question
| February 14, 2008 4:14 AM
SQL Server 2000, SQL Server administration
i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.
Answer Question
| February 14, 2008 4:14 AM
SQL Server 2000, SQL Server administration
Cache Policy
We are modelling a cube in analysis services 2005 which has custom rollup due to which the performance is very slow. If i use this property cache policy=9 the performance increases a bit. I tried it in 2 ways: 1. I changed the value of calculation cover policy to 9 in msmdsrv.ini . 2.I added [...]
Answer Question
| February 14, 2008 1:40 PM
SQL Server
We are modelling a cube in analysis services 2005 which has custom rollup due to which the performance is very slow. If i use this property cache policy=9 the performance increases a bit. I tried it in 2 ways: 1. I changed the value of calculation cover policy to 9 in msmdsrv.ini . 2.I added [...]
Answer Question
| February 14, 2008 1:40 PM
SQL Server
Will cache policy=9 work in system that has MS analysis services 2000 or MS Analysis services 2005.
Will cache policy=9 work in system that has MS analysis services 2000 or MS Analysis services 2005.
Answer Question
| February 13, 2008 7:53 AM
SQL Server
Will cache policy=9 work in system that has MS analysis services 2000 or MS Analysis services 2005.
Answer Question
| February 13, 2008 7:53 AM
SQL Server
how to run sql server 2000 on terminal which is logged on as user having limited rights
how to run sql server 2000 on terminal which is lgged on as user having limited rights
Answer Question
| February 13, 2008 4:13 AM
SQL Server 2000
how to run sql server 2000 on terminal which is lgged on as user having limited rights
Answer Question
| February 13, 2008 4:13 AM
SQL Server 2000
Using Veritas for SQL clustering
I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.
Answer Question
| March 5, 2008 7:20 PM
MSSC, SQL Server clustering, VCS
I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.
Answer Question
| March 5, 2008 7:20 PM
MSSC, SQL Server clustering, VCS
SQL Server Job Example using sp_start_job
I need to use sp_start_job to schedule two jobs in SQL Server : the second job may run only if the first succeds. Can you give me an example of a job running this store procedure to do this ? Is there another method to do this in SQL Server ? Thanks in advance !
Answer Question
| April 22, 2011 6:44 PM
sp_start_job, SQL Server
I need to use sp_start_job to schedule two jobs in SQL Server : the second job may run only if the first succeds. Can you give me an example of a job running this store procedure to do this ? Is there another method to do this in SQL Server ? Thanks in advance !
Answer Question
| April 22, 2011 6:44 PM
sp_start_job, SQL Server
How to manipulate data or values in my tables SQL Server
A question emailed to us i can now connect the database i made (in mssql server) but the problem is i do not know how to manipulate the data or values in my tables. for example, in my login program. i do not know how to declare that the input of the user must compare [...]
Answer Question
| February 13, 2008 2:18 PM
Database, SQL Server
A question emailed to us i can now connect the database i made (in mssql server) but the problem is i do not know how to manipulate the data or values in my tables. for example, in my login program. i do not know how to declare that the input of the user must compare [...]
Answer Question
| February 13, 2008 2:18 PM
Database, SQL Server
Automating an application
I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I [...]
Answer Question
| February 8, 2008 12:04 PM
SQL Server 2000, VB
I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I [...]
Answer Question
| February 8, 2008 12:04 PM
SQL Server 2000, VB
Can anyone suggest a good loan APR formula in SQL
I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?
Answer Question
| July 25, 2011 6:38 PM
Excel Rate function, SQL, SQL IIR
I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?
Answer Question
| July 25, 2011 6:38 PM
Excel Rate function, SQL, SQL IIR
using a local variable to build an sql-statement beyond datatype nvarchar(4000) and execute with sp_executesql
I build a sql-statement and put it in a local variable so i can execute it using sp_executesql, but a local variable cannot be a text or ntext data type, and a varchar data type cannot be used by sp_executesql. So the maximum lenght of the statement cannot be more than nvarchar(4000)… is there any [...]
Answer Question
| February 6, 2008 4:59 PM
SQL, SQL Server
I build a sql-statement and put it in a local variable so i can execute it using sp_executesql, but a local variable cannot be a text or ntext data type, and a varchar data type cannot be used by sp_executesql. So the maximum lenght of the statement cannot be more than nvarchar(4000)… is there any [...]
Answer Question
| February 6, 2008 4:59 PM
SQL, SQL Server
Insert and update DB2 from SQL Server 2000 using OLEDB
I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, [...]
Answer Question
| June 29, 2010 9:42 AM
AS/400, DTS, SQL Server 2000
I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, [...]
Answer Question
| June 29, 2010 9:42 AM
AS/400, DTS, SQL Server 2000
SQL Server 2005 Express issue…
Hallo, we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on SERVER [...]
Answer Question
| February 9, 2008 7:30 AM
SQL Server
Hallo, we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on SERVER [...]
Answer Question
| February 9, 2008 7:30 AM
SQL Server
Community Message: Answer these questions and earn Knowledge Points
Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. [...]
Answer Question
| February 6, 2008 8:40 PM
AS/400, Database, DataCenter, Development, Exchange, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, VoIP
Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. [...]
Answer Question
| February 6, 2008 8:40 PM
AS/400, Database, DataCenter, Development, Exchange, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, VoIP
naming column returned from FOR XML EXPLICIT query in SQL Server 2005
Is there a way to name the column returned from a query that includes a for xml explicit ? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I’d like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into @RoleIDs (RoleID) select 1 insert into [...]
Answer Question
| February 8, 2008 6:12 PM
SQL Server 2005, XML
Is there a way to name the column returned from a query that includes a for xml explicit ? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I’d like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into @RoleIDs (RoleID) select 1 insert into [...]
Answer Question
| February 8, 2008 6:12 PM
SQL Server 2005, XML
rows to columns
I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny doe 1000 [...]
Answer Question
| February 22, 2008 2:04 PM
SQL, SQL Server
I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny doe 1000 [...]
Answer Question
| February 22, 2008 2:04 PM
SQL, SQL Server
SQL SERVER 2005 XML LOAD
Hi EVeryone, Having a text file (in which resides the xml data and the xml schema definition),i have to create the afilliate tables to that XML(+XSD).The problem is the XSD is variable , and can not be hardcoded, i mean that XSD could vary from file to file… Is there a way to create automatically [...]
Answer Question
| March 29, 2010 11:11 AM
SQL Server 2005, XML
Hi EVeryone, Having a text file (in which resides the xml data and the xml schema definition),i have to create the afilliate tables to that XML(+XSD).The problem is the XSD is variable , and can not be hardcoded, i mean that XSD could vary from file to file… Is there a way to create automatically [...]
Answer Question
| March 29, 2010 11:11 AM
SQL Server 2005, XML
Reverse engineering replication
I would like an “automated” way to “script out” existing replication for SQL Server 2005. Does anyone have a method for this? Thanks.
Answer Question
| February 1, 2008 7:19 PM
reverse engineering replication, scripting replication, SQL Server 2005 replication
I would like an “automated” way to “script out” existing replication for SQL Server 2005. Does anyone have a method for this? Thanks.
Answer Question
| February 1, 2008 7:19 PM
reverse engineering replication, scripting replication, SQL Server 2005 replication
Stored Procedure
I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure. Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got the desired result. The [...]
Answer Question
| July 19, 2008 2:35 PM
ADO.NET, SQL stored procedures
I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure. Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got the desired result. The [...]
Answer Question
| July 19, 2008 2:35 PM
ADO.NET, SQL stored procedures
SQL
How to find out if database are crypted
Answer Question
| January 31, 2008 9:54 PM
SQL Server administration
How to find out if database are crypted
Answer Question
| January 31, 2008 9:54 PM
SQL Server administration
SQL Command
I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ‘ : ‘+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in (’102200′,’102083′)) and (substring(p.PO_CODE ,5,1) = ‘R’ ) and (p.cancel = ‘N’ and [...]
Answer Question
| February 12, 2008 3:09 AM
SQL Server 2000, Stored Procedures, T-SQL
I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ‘ : ‘+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in (’102200′,’102083′)) and (substring(p.PO_CODE ,5,1) = ‘R’ ) and (p.cancel = ‘N’ and [...]
Answer Question
| February 12, 2008 3:09 AM
SQL Server 2000, Stored Procedures, T-SQL
