execute as with synonym
Yes this can be done. 1. Create the new Login for domainsrvc and then create a database user from the Login in database A. USE database A GO CREATE USER [domainsrvc] FROM LOGIN [domainsrvc] 2. Grant authority to the User domainsrvc in database A to enable them to delete data from the table. 3. Create [...]
View Answer
| August 11, 2009 6:42 PM
SQL Database, SQL stored procedures, Stored Procedures
Yes this can be done. 1. Create the new Login for domainsrvc and then create a database user from the Login in database A. USE database A GO CREATE USER [domainsrvc] FROM LOGIN [domainsrvc] 2. Grant authority to the User domainsrvc in database A to enable them to delete data from the table. 3. Create [...]
View Answer
| August 11, 2009 6:42 PM
SQL Database, SQL stored procedures, Stored Procedures
jasper server with sql server
get ur answer through jasper server.com,u can clear it ESH says: If you use jtds as your db driver, yes. It can be used in iReport or on Jasper server. JDBC driver class: net.sourceforge.jtds.jdbc.Driver JDBC URL: jdbc:jtds:sqlserver://serverName/dbName;instance=
View Answer
| August 11, 2009 4:04 PM
JasperServer, JDBC, SQL Server
get ur answer through jasper server.com,u can clear it ESH says: If you use jtds as your db driver, yes. It can be used in iReport or on Jasper server. JDBC driver class: net.sourceforge.jtds.jdbc.Driver JDBC URL: jdbc:jtds:sqlserver://serverName/dbName;instance=
View Answer
| August 11, 2009 4:04 PM
JasperServer, JDBC, SQL Server
SQL Server 2005 – Unable to Eun a Pull Subscription due to “unable to connect to distributor” error
Can you use SSMS on Server2 to connect to the SQL Instance on Server1?
View Answer
| August 6, 2009 9:12 PM
SQL Server 2005, SQL Server replication
Can you use SSMS on Server2 to connect to the SQL Instance on Server1?
View Answer
| August 6, 2009 9:12 PM
SQL Server 2005, SQL Server replication
view active directory data using SQL server 2005
There’s lots of information out there about querying AD from SQL Server. Just Google for ADSI Linked Server and you should find a ton of it.
View Answer
| August 6, 2009 9:11 PM
Active Directory, SQL Server 2005
There’s lots of information out there about querying AD from SQL Server. Just Google for ADSI Linked Server and you should find a ton of it.
View Answer
| August 6, 2009 9:11 PM
Active Directory, SQL Server 2005
Adding data in SQL 2005 server
Columns that are part of the primary key, or that have been declared with a NOT NULL constraint will not accept nulls. In order to be able to insert nulls you will have the alter the table definition. Let us know if you need further help.
View Answer
| August 6, 2009 2:24 PM
SQL Server 2005, SQL Server database
Columns that are part of the primary key, or that have been declared with a NOT NULL constraint will not accept nulls. In order to be able to insert nulls you will have the alter the table definition. Let us know if you need further help.
View Answer
| August 6, 2009 2:24 PM
SQL Server 2005, SQL Server database
In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.
DB/2 on what platform? Locking occurs because of commitment level setting commitment level depends on the environment you are issuing the Select from. Summary: Need to know Platform? Need to know Programming tool that select is issued from? Phil Hi, I’m using DB2 in AIX environment. That is what I can give u the details [...]
View Answer
| August 5, 2009 8:01 PM
DB2, DB2 query, SELECT statement
DB/2 on what platform? Locking occurs because of commitment level setting commitment level depends on the environment you are issuing the Select from. Summary: Need to know Platform? Need to know Programming tool that select is issued from? Phil Hi, I’m using DB2 in AIX environment. That is what I can give u the details [...]
View Answer
| August 5, 2009 8:01 PM
DB2, DB2 query, SELECT statement
Changing the sql server service and agent windows account password
It’s actually a very easy change to make. It will require that you restart the SQL Services on all your services though. Use the Services Admin Tool (or control panel applet on Windows 2000) to change the password for the actual services on all the servers. Do NOT restart the services yet. Once all the [...]
View Answer
| August 5, 2009 7:33 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services
It’s actually a very easy change to make. It will require that you restart the SQL Services on all your services though. Use the Services Admin Tool (or control panel applet on Windows 2000) to change the password for the actual services on all the servers. Do NOT restart the services yet. Once all the [...]
View Answer
| August 5, 2009 7:33 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services
Encrypt the password in SQL 2000
There’s no way to pass the password in an already encrypted form. What you can do, it store the connection string in an encrypted form in the config file, then when the app loads, load the encrypted connection string, and decrypted it in memory and use the then decrypted connection string to connect. This way [...]
View Answer
| August 4, 2009 7:05 PM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB
There’s no way to pass the password in an already encrypted form. What you can do, it store the connection string in an encrypted form in the config file, then when the app loads, load the encrypted connection string, and decrypted it in memory and use the then decrypted connection string to connect. This way [...]
View Answer
| August 4, 2009 7:05 PM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB
SQL Server 2008: Difficulty setting mixed mode authentication password
Starting with SQL Server 2005, the sa password (which is the password you are trying to set) must meet your domain’s password complexity requirements. So what ever complexity requirements your domain has set for your Windows password you will also need to use for the sa password.
View Answer
| August 4, 2009 6:57 PM
SQL Server 2008, SQL Server 2008 64-bit, SQL Server authentication, SQL Server installation, Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 R2 x64
Starting with SQL Server 2005, the sa password (which is the password you are trying to set) must meet your domain’s password complexity requirements. So what ever complexity requirements your domain has set for your Windows password you will also need to use for the sa password.
View Answer
| August 4, 2009 6:57 PM
SQL Server 2008, SQL Server 2008 64-bit, SQL Server authentication, SQL Server installation, Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 R2 x64
SQL Select: Getting the previous records from a known record
I guess this is on DB2, and I’m not sure how the ‘FETCH FIRST x ROWS’ works in conjunction with an ORDER BY clause, but <b>if it applies the order first, and then fetches the x rows</b>, then this should work: <pre>Select phone# from pltlcd where phone# < 985143525 order by phone# desc fetch first [...]
View Answer
| August 4, 2009 6:01 PM
SELECT statement, SQL Select, SQL Select statement problem
I guess this is on DB2, and I’m not sure how the ‘FETCH FIRST x ROWS’ works in conjunction with an ORDER BY clause, but <b>if it applies the order first, and then fetches the x rows</b>, then this should work: <pre>Select phone# from pltlcd where phone# < 985143525 order by phone# desc fetch first [...]
View Answer
| August 4, 2009 6:01 PM
SELECT statement, SQL Select, SQL Select statement problem
Error during SQL Server 2000 installation
The enterprise edition can only be installed on a server operating system. If you want to install Sql Server 2000 on XP, you will need to install the Personal or Developer editions, or the Desktop Engine (MSDE).
View Answer
| August 3, 2009 7:12 PM
SQL Server 2000, SQL Server error messages, SQL Server installation
The enterprise edition can only be installed on a server operating system. If you want to install Sql Server 2000 on XP, you will need to install the Personal or Developer editions, or the Desktop Engine (MSDE).
View Answer
| August 3, 2009 7:12 PM
SQL Server 2000, SQL Server error messages, SQL Server installation
SQL select command
Using DISTINCT didn’t work, because it filters out records in which all fields are duplicated. You need to use a GROUP BY statement. I don’t see a column “Bprice” in your query, so I will assume that it is “biddings.price” <pre>SELECT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, MAX (biddings.price) FROM customers, biddings, [...]
View Answer
| August 3, 2009 6:56 AM
SQL, SQL commands, SQL Select
Using DISTINCT didn’t work, because it filters out records in which all fields are duplicated. You need to use a GROUP BY statement. I don’t see a column “Bprice” in your query, so I will assume that it is “biddings.price” <pre>SELECT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, MAX (biddings.price) FROM customers, biddings, [...]
View Answer
| August 3, 2009 6:56 AM
SQL, SQL commands, SQL Select
SQL Server tables – What account created the object
If your database is in full recovery mode and you have Lumigent’s Log Explorer or Quest Software’s LiteSpeed for SQL Server then you can look through the Transaction Log and see who did what. If not, if you have SQL Server 2008 you can enable auditing to track this information going forward. If you have [...]
View Answer
| August 2, 2009 8:47 PM
SQL Server administration, SQL Server tables
If your database is in full recovery mode and you have Lumigent’s Log Explorer or Quest Software’s LiteSpeed for SQL Server then you can look through the Transaction Log and see who did what. If not, if you have SQL Server 2008 you can enable auditing to track this information going forward. If you have [...]
View Answer
| August 2, 2009 8:47 PM
SQL Server administration, SQL Server tables
SQL Server: Index and Key
That would be i-series talk — missed the keywords Do your select on the physical file or the view. The view’s select should be on the physical file. Don’t do your select on a logical. Include the where clause to define which records you want. Include the order by clause to indicate the delivery order [...]
View Answer
| August 1, 2009 8:55 PM
Index and Key, SELECT statement
That would be i-series talk — missed the keywords Do your select on the physical file or the view. The view’s select should be on the physical file. Don’t do your select on a logical. Include the where clause to define which records you want. Include the order by clause to indicate the delivery order [...]
View Answer
| August 1, 2009 8:55 PM
Index and Key, SELECT statement
Memory overhead recommended for benchmarking SQL server 2005 on vSphere
You shouldn’t need to. The OS on both the physical and virtual servers should need the same amount of overhead. For the VM the host OS will take the memory overhead that it needs from the host’s memory not the guests. If you were going to give the VM memory to cover the overhead, most [...]
View Answer
| July 31, 2009 10:15 PM
Physical hosts, SQL Server 2005, SQL Server memory, Virtual Machines, vSphere
You shouldn’t need to. The OS on both the physical and virtual servers should need the same amount of overhead. For the VM the host OS will take the memory overhead that it needs from the host’s memory not the guests. If you were going to give the VM memory to cover the overhead, most [...]
View Answer
| July 31, 2009 10:15 PM
Physical hosts, SQL Server 2005, SQL Server memory, Virtual Machines, vSphere
SQL Server Profiler’s TextData Column Has NULL And Longest Duration value
It could be any number of things. What events were you capturing?
View Answer
| July 30, 2009 9:10 PM
SQL Profiler, SQL Server 2005, SQL Server Profiler
It could be any number of things. What events were you capturing?
View Answer
| July 30, 2009 9:10 PM
SQL Profiler, SQL Server 2005, SQL Server Profiler
SQL Server Database Date Time Values
This can’t be done in SQL 2000 as long as you are using the DATETIME data type. Microsoft didn’t begin offering the DATE and the TIME data types until SQL Server 2008 was released. You’ll need to store the entire datetime value and then only display the part that you need. You might consider upgrading [...]
View Answer
| July 30, 2009 8:59 PM
SQL Server 2000, SQL Server database
This can’t be done in SQL 2000 as long as you are using the DATETIME data type. Microsoft didn’t begin offering the DATE and the TIME data types until SQL Server 2008 was released. You’ll need to store the entire datetime value and then only display the part that you need. You might consider upgrading [...]
View Answer
| July 30, 2009 8:59 PM
SQL Server 2000, SQL Server database
Join Logical files and SQL views
You’re right views aren’t the same as joins. A view contains the rules for selecting records — rules no keys (indexes) SQL Indexes can be created on the physical files. Indexes are keys – no rules (some rules in v6r1). If the indexes needed don’t exist SQL will create temp indexes. SQL will analyze the [...]
View Answer
| July 30, 2009 6:47 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View
You’re right views aren’t the same as joins. A view contains the rules for selecting records — rules no keys (indexes) SQL Indexes can be created on the physical files. Indexes are keys – no rules (some rules in v6r1). If the indexes needed don’t exist SQL will create temp indexes. SQL will analyze the [...]
View Answer
| July 30, 2009 6:47 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View
SQL Error
I suppose that you use ORDER BY in a subquery. This is not admitted without use of TOP clause (SQL Server). If you need all rows from subquery, you can use this trick <pre>SELECT TOP 100 PERCENT … ORDER BY … </pre>
View Answer
| July 30, 2009 3:57 PM
SQL, SQL error messages
I suppose that you use ORDER BY in a subquery. This is not admitted without use of TOP clause (SQL Server). If you need all rows from subquery, you can use this trick <pre>SELECT TOP 100 PERCENT … ORDER BY … </pre>
View Answer
| July 30, 2009 3:57 PM
SQL, SQL error messages
learning-sql-part-2
Any book on SQL — Access supports 85% of the standard. This isn’t the best way to go. I think it will be very slow – SQL is running on you PC and every record from the 400 must be sent even if it’s eventually excluded by your Query. You can run SQL from your [...]
View Answer
| October 9, 2012 3:48 PM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
Any book on SQL — Access supports 85% of the standard. This isn’t the best way to go. I think it will be very slow – SQL is running on you PC and every record from the 400 must be sent even if it’s eventually excluded by your Query. You can run SQL from your [...]
View Answer
| October 9, 2012 3:48 PM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
