change track in sql server 2008
If you look at the bar at the bottom of SQL Management Studio it’ll tell you the user account which you are connected with.
View Answer
| May 25, 2010 4:16 AM
DB tracking, SQL Server, SQL Server 2008
If you look at the bar at the bottom of SQL Management Studio it’ll tell you the user account which you are connected with.
View Answer
| May 25, 2010 4:16 AM
DB tracking, SQL Server, SQL Server 2008
SQL Server schema
<pre>select * from sys.sysusers (nolock) or select * from sys.database_principals (nolock)</pre> This will get you the list of “named” users of the database. <pre>select * from sys.server_principals (nolock) where type_desc = ‘WINDOWS_LOGIN’</pre> This will get you the list of users authorized by their Windows authentications. (This is probably what you really want.)
View Answer
| May 24, 2010 7:46 PM
SQL Server, SQL Server schema, T-SQL
<pre>select * from sys.sysusers (nolock) or select * from sys.database_principals (nolock)</pre> This will get you the list of “named” users of the database. <pre>select * from sys.server_principals (nolock) where type_desc = ‘WINDOWS_LOGIN’</pre> This will get you the list of users authorized by their Windows authentications. (This is probably what you really want.)
View Answer
| May 24, 2010 7:46 PM
SQL Server, SQL Server schema, T-SQL
Data Warehouse Query Performance
Accessing more data will take more resources (time, I/O, sort, etc). But it will not take 5 times as long. Too many variables come into play to be able to calculate without running some benchmarks.
View Answer
| May 21, 2010 2:07 PM
Cognos, Data Warehouse Testing, SQL Server
Accessing more data will take more resources (time, I/O, sort, etc). But it will not take 5 times as long. Too many variables come into play to be able to calculate without running some benchmarks.
View Answer
| May 21, 2010 2:07 PM
Cognos, Data Warehouse Testing, SQL Server
What is SQL Azure?
Microsoft SQL Azure extends SQL Server capabilities to the cloud. SQL Azure offers a relational database service called Microsoft SQL Azure Database, and using SQL Azure, you can easily provision and deploy relational database solutions in the cloud — more details at http://www.microsoft.com/windowsazure/sqlazure/ ———— SQL Azure is a cloud database platform where you can host [...]
View Answer
| May 20, 2010 10:46 PM
SQL Azure, SQL Server 2008 R2
Microsoft SQL Azure extends SQL Server capabilities to the cloud. SQL Azure offers a relational database service called Microsoft SQL Azure Database, and using SQL Azure, you can easily provision and deploy relational database solutions in the cloud — more details at http://www.microsoft.com/windowsazure/sqlazure/ ———— SQL Azure is a cloud database platform where you can host [...]
View Answer
| May 20, 2010 10:46 PM
SQL Azure, SQL Server 2008 R2
Which tool is best in all aspects?
No one tool is best for *everything* – that is why there are different ones. building an application system is different than a one off ad hoc query. You wouldn’t pick just one size of a Phillips head screw driver and expect to use it for every screw.
View Answer
| May 20, 2010 2:31 PM
Oracle, PL/SQL Developer, SQL Developer, TOAD
No one tool is best for *everything* – that is why there are different ones. building an application system is different than a one off ad hoc query. You wouldn’t pick just one size of a Phillips head screw driver and expect to use it for every screw.
View Answer
| May 20, 2010 2:31 PM
Oracle, PL/SQL Developer, SQL Developer, TOAD
About MCTS 70-432 Certification
I’m biased since I wrote <a href=”http://www.amazon.com/Real-MCTS-Server-2008-70-432/dp/1597494208/ref=ntt_at_ep_dpt_1″>part of this book</a>, but it should help.
View Answer
| May 19, 2010 5:21 AM
IT training and certifications, mcts 70-432 certification, SQL Server
I’m biased since I wrote <a href=”http://www.amazon.com/Real-MCTS-Server-2008-70-432/dp/1597494208/ref=ntt_at_ep_dpt_1″>part of this book</a>, but it should help.
View Answer
| May 19, 2010 5:21 AM
IT training and certifications, mcts 70-432 certification, SQL Server
Looking for Backup solution for VMWare environment
<a href=”http://www.vizioncore.com/products/vRangerPro/index.php”>Vranger Pro </a> may be a good solution for you. We use vranger to back up our vm servers to disk on the vranger server which is retained for 3 days, then that server is backed up to tape by TSM. Restoring from TSM then restoring the vm from vranger is a very easy [...]
View Answer
| May 19, 2010 4:54 AM
ESX4, SQL 2005, TSM Backup, Veeam, Virtualization in 2010, VMware Server
<a href=”http://www.vizioncore.com/products/vRangerPro/index.php”>Vranger Pro </a> may be a good solution for you. We use vranger to back up our vm servers to disk on the vranger server which is retained for 3 days, then that server is backed up to tape by TSM. Restoring from TSM then restoring the vm from vranger is a very easy [...]
View Answer
| May 19, 2010 4:54 AM
ESX4, SQL 2005, TSM Backup, Veeam, Virtualization in 2010, VMware Server
sql server 2008 backup and restore
The command should look something like this. <pre>RESTORE DATABASE YourDatabaseName FROM DISK=’D:nor.bak’</pre> The command gets more complex if you don’t have the files and folders laid out the same.
View Answer
| May 19, 2010 4:44 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore
The command should look something like this. <pre>RESTORE DATABASE YourDatabaseName FROM DISK=’D:nor.bak’</pre> The command gets more complex if you don’t have the files and folders laid out the same.
View Answer
| May 19, 2010 4:44 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore
Add an Active node to SQL Server Active Passive Cluster
You just need to add the node to the cluster, then install the SQL Server software on it. Now you can’t run a single instance of SQL Server across two nodes of the customer. A single instance can only run on one node of the cluster at any one time. Clustering isn’t to increase server [...]
View Answer
| May 19, 2010 4:40 AM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server clustering
You just need to add the node to the cluster, then install the SQL Server software on it. Now you can’t run a single instance of SQL Server across two nodes of the customer. A single instance can only run on one node of the cluster at any one time. Clustering isn’t to increase server [...]
View Answer
| May 19, 2010 4:40 AM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server clustering
Can’t see step info in an existing job SQL Server
Please give us some more information. To start – Old machine OS / SQL Server version New machine OS / SQL Server version Are user permissions set on the local machine, or are these coming from GPOs?
View Answer
| May 16, 2010 4:06 AM
SQL Server Agent, SQL Server Agent Jobs, SQL Server configuration
Please give us some more information. To start – Old machine OS / SQL Server version New machine OS / SQL Server version Are user permissions set on the local machine, or are these coming from GPOs?
View Answer
| May 16, 2010 4:06 AM
SQL Server Agent, SQL Server Agent Jobs, SQL Server configuration
Source code for multiuser programming in VB 6 with SQL Server 2000
<pre></pre>
View Answer
| May 14, 2010 2:41 PM
Database programming, Multiuser application, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6
<pre></pre>
View Answer
| May 14, 2010 2:41 PM
Database programming, Multiuser application, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6
sql
Yes you can download oracle and java. Open Google then type (oracle / java download) . -HarshitRedhat9250588803 You should download the express editions of Visual Studio and Oracle database, which are the free versions of those products. -CarlosDL
View Answer
| May 14, 2010 1:52 PM
Java, Java vs Oracle, SQL Server, SQL Server Training
Yes you can download oracle and java. Open Google then type (oracle / java download) . -HarshitRedhat9250588803 You should download the express editions of Visual Studio and Oracle database, which are the free versions of those products. -CarlosDL
View Answer
| May 14, 2010 1:52 PM
Java, Java vs Oracle, SQL Server, SQL Server Training
How to Make Fixed Row Table
You could use a CHECK constraint. Semething like this: <pre>CREATE FUNCTION CheckFnctn() RETURNS int AS BEGIN DECLARE @retval int SELECT @retval = COUNT(*) FROM yourTable RETURN @retval END; GO ALTER TABLE yourTable ADD CONSTRAINT chkRowCount CHECK (dbo.CheckFnctn() <= 500 ); GO</pre> -CarlosDL
View Answer
| May 12, 2010 3:47 PM
SQL Server, SQL Server 2008, SQL tables
You could use a CHECK constraint. Semething like this: <pre>CREATE FUNCTION CheckFnctn() RETURNS int AS BEGIN DECLARE @retval int SELECT @retval = COUNT(*) FROM yourTable RETURN @retval END; GO ALTER TABLE yourTable ADD CONSTRAINT chkRowCount CHECK (dbo.CheckFnctn() <= 500 ); GO</pre> -CarlosDL
View Answer
| May 12, 2010 3:47 PM
SQL Server, SQL Server 2008, SQL tables
Is an existing BI solution required to use the BI capabilities of SQL Server R2?
No existing BI solutions are required for using the BI capabilities of SQL Server 2008 R2. You can build new BI solutions using SQL Server 2008 R2. With SQL Server 2008 R2 we are simply adding more functionality by expanding our offering toe more extensively cover the areas of self service BI. So with SQL [...]
View Answer
| May 12, 2010 1:42 AM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features
No existing BI solutions are required for using the BI capabilities of SQL Server 2008 R2. You can build new BI solutions using SQL Server 2008 R2. With SQL Server 2008 R2 we are simply adding more functionality by expanding our offering toe more extensively cover the areas of self service BI. So with SQL [...]
View Answer
| May 12, 2010 1:42 AM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features
oracle 9i in windows 7
Oracle 9i is definitely not supported on windows 7. You could try installing 10g and it may work, but AFAIK it is also unsupported on 7 for now.
View Answer
| May 11, 2010 1:50 PM
Oracle 9i, Oracle 9i installation errors, SQL Plus, Windows 7
Oracle 9i is definitely not supported on windows 7. You could try installing 10g and it may work, but AFAIK it is also unsupported on 7 for now.
View Answer
| May 11, 2010 1:50 PM
Oracle 9i, Oracle 9i installation errors, SQL Plus, Windows 7
embedding sql to rpgle
This is actually more of a math function. Get 2 fields defined as date format. From date is Jan 1st of the year desired. Thru date is your target (maybe today’s date ?) $TDATE Subdur $FDATE $DDIFF:*W I think it allows *W for Weeks. If not, use *D for Days then divide by 7 to [...]
View Answer
| May 11, 2010 1:20 AM
AS/400, Embedded SQL, RPGLE, SQL Server
This is actually more of a math function. Get 2 fields defined as date format. From date is Jan 1st of the year desired. Thru date is your target (maybe today’s date ?) $TDATE Subdur $FDATE $DDIFF:*W I think it allows *W for Weeks. If not, use *D for Days then divide by 7 to [...]
View Answer
| May 11, 2010 1:20 AM
AS/400, Embedded SQL, RPGLE, SQL Server
Cost to Upgrade to SQL Server 2008 R2
With SQL Server 2008 R2, Microsoft continues to be the value leader, offering rich functionality to support OLTP and BI workloads out of the box at a low cost of ownership relative to competitors. With increasing hardware innovations, Microsoft continues to be the only major database vendor who does not price per core for multi-core [...]
View Answer
| May 10, 2010 8:15 PM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008 R2
With SQL Server 2008 R2, Microsoft continues to be the value leader, offering rich functionality to support OLTP and BI workloads out of the box at a low cost of ownership relative to competitors. With increasing hardware innovations, Microsoft continues to be the only major database vendor who does not price per core for multi-core [...]
View Answer
| May 10, 2010 8:15 PM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008 R2
Managed Self Service Approach to BI
Managed self service BI can benefit your organization in multiple ways: First of all it will allow more users to do BI due to ease of use of the tools. Secondly it will allow your organization build and manage BI solutions more efficiently. Why? By allowing the business users with the domain expertise to serve [...]
View Answer
| May 10, 2010 8:14 PM
Business Intelligence, SQL Server 2008 R2
Managed self service BI can benefit your organization in multiple ways: First of all it will allow more users to do BI due to ease of use of the tools. Secondly it will allow your organization build and manage BI solutions more efficiently. Why? By allowing the business users with the domain expertise to serve [...]
View Answer
| May 10, 2010 8:14 PM
Business Intelligence, SQL Server 2008 R2
Calling an Oracle stored procedure from SQL Server
Yes it is. You will need to setup a linked server from the SQL Server to the Oracle server. Then use the three part name of the procedure you want to run. Don’t forget the double dot to convert the Oracle three part name into the SQL Server four part name. <pre>exec OracleServer..Schema.Object</pre> When setting [...]
View Answer
| May 10, 2010 2:46 PM
Oracle, SQL Server, Stored Procedures
Yes it is. You will need to setup a linked server from the SQL Server to the Oracle server. Then use the three part name of the procedure you want to run. Don’t forget the double dot to convert the Oracle three part name into the SQL Server four part name. <pre>exec OracleServer..Schema.Object</pre> When setting [...]
View Answer
| May 10, 2010 2:46 PM
Oracle, SQL Server, Stored Procedures
Are ITKE and MicrosoftExpert just shills for Microsoft?
They are questions from the chats that they have on the site. It is not intended to be marketing speak but if users feel that these types of messages arent appropriate for the community we can stop.
View Answer
| May 7, 2010 10:10 PM
Marketing, Microsoft, SQL Server
They are questions from the chats that they have on the site. It is not intended to be marketing speak but if users feel that these types of messages arent appropriate for the community we can stop.
View Answer
| May 7, 2010 10:10 PM
Marketing, Microsoft, SQL Server
