Answer Questions

• VasudevaKumarAtukuri Can not create unsafe assembly

  I try to create assembly with UNSAFE permissions. I granted "unsafe assembly" to my login, set TRUSTWORTHY property ON. Now I have this error: Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5. (Microsoft SQL Server, Error: 15404). How to resolve this Looks like your server isn't able to reach the D.C. to get information on your particular ...Show All

• WEPHenn How to take a SP like a table

  Hi Any one knows how to take a SP(stored procedure) like a table, obviously the SP throws a search or other way that can help me is if when I execute a varchar, but i want to manipulate like a table, the varchar has a simple search like select * from user Thanks for your help You can use OPENQUERY for that: http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thre ...Show All

• RobertW Creating MS Access datasource

  I am trying to create a MS Access datasource to use it in a IS dataflow. I've done the following things: 1.I've created an ODBC datasource - System DSN, pointing to the Access database. 2.I've created an ODBC connection manager pointing to the ODBS datasource that I created in the previous step. 3.I've created a DataReader Source that uses as its Connection Manager the connection manager that I created in the previous step. I get the ...Show All

• JohnWC Complex Transformations (SSIS components vs TSQL)

  Greetings SSIS friends, I have been attempting to implement one of our numerous ETL processes in SSIS but hit a brick wall when I tried replacing a complex stored procedure with a series of Merge Join components. In the end, I had to settle with using a SQL task which merely calls the stored procedure and this proved to be the better option as the other version where I used SSIS components only took forever to run. How do people c ...Show All

• Mikee_ko Pass custom cookie from external web application to Report Manager

  I want to accomplish a Single Sign On from my web application to Report Manager. I am trying to pass a custom cookie from my web application to Report Manager so when it redirects to my login page, I can authenticate the user with the cookie values. I try setting the PassThroughCookies section in the config file but the cookie is still being lost on the Report Manager end. Also, is there a reason why the web.config for Report Manager still has W ...Show All

• BahKoo51 Syntax for "In" Operator

  Does anyone know what the syntax for the "In" operator is when setting a filter on a matrix. Any clue on this. I have tried (value,value), value;value, value,value. and multiple other combinations. I have been unsuccessful on finding anthing about this. No dice. Still not able to use 'IN' operator for table filter. Perhaps quotes would work ...Show All

• pmak Setting SQL server Express maximum memory usage

  Hi All, How can we set the maximum memory usage for SQL server Express I have tried setting it in Microsoft SQL Server Management Studio Express - Memory option, but it didn't have any effect.A problem I'm facing now is that the sqlservr memory usage keeps increasing and eventually slows down my application. Is there a way to set the upper limit or clear the unused memory Thank you. Regards, Lawrence Hi a ...Show All

• DeeD can't get the complete list of tables owned by the dbo

  Hi, i am using sp_tables to get the list of the tables in the database owned by dbo The database i am trying to query would let me query all the tables present in the database.there are almost a 1000 of them(owned by dbo) .I can query them and i get the records.   But the execution of the stored procedure  "sp_tables"  would return only 10 or so  tables.I was puzzled by this.   can someone clar ...Show All

• Nisha Pai Alerting on SQL Server events in SQL Server 2005

  In SQL Server 2000 I have several Alerts set to respond to SQL Server events. One in particular is 3738 which lets me know a database is deleted. In SQL Server 2005, this event is not set to log, and therefore I am not getting the alert to fire. I tried to run sp_altermessage, but it will not let you modify system messages. I configured a WMI alert to trigger off of SELECT * FROM DROP_DATABASE, and this tells me that a database has been deleted ...Show All

• He Hua script in removing primary key..

  help, I need it now, I need a script for removing a primary key constraint. thanks The name of the constraint -- every primary key is named.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < yngielkoh@discussions..microsoft.com > wrote in message news:effa9b68-2bab-4afb-a96b-0e2c1 ...Show All

• Adnanans78 creating tables

  I am trying to go through an arraylist and create some database tables for each entry in the array. what I have is Dim ques As String For Each ques In questions query = "create Table " + ques + " (plantid nvarchar(100), Answer nvarchar(100))" cmd = New SqlCeCommand(query, con) cmd.ExecuteNonQuery() Next I am wanting to use the item in the arraylist as the name of the db. I am getting an error saying ...Show All

• Alfred Kelgarries About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• Jacques Laurin Visual Basic with SQL-database connection and Windows XP

  When you work with Visual Basic 2005 Express Edition on windows XP, and if your application contains references to SQL-databases, I have discovered that it is important that all identities be logged off before you open the particular identity where you want to work on your Visual Basic project. I have earlier assumed that it was only possible to work with Visual Basic on one identity, the one where the version was registered. ...Show All

• EastCore Saving Auto Recovery Information

  Hi I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information. The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress. How can I change the location of the recovery files or turn off the Auto Recovery functionalit ...Show All

• Igore65 Assembly MyAssembly was not found in the SQL catalog of database MyDB

  I’m trying to register my CLR UDF in SQL 2005 using this code   CREATE FUNCTION GetSomething() RETURNS INT AS EXTERNAL NAME MyAssembly.MyFunction.MyMethod   When I run it against my DB I get this error: Assembly MyAssembly was not found in the SQL catalog of database MyDB   I’ve successfully registered my custom assembly in the DB (I see it under Assemblies folder), and I’ve set CRL Enabled to 1 in my DB.   ...Show All