CustomQueryDesigner Problem: React To Resize Event Of QueryDesigner Window
Feb 5, 2007
Hello everybody!
I am currently developing a CustomQueryDesigner which is based on a Windows.Form that I have already developed.
Currently the QueryDesigner Class contains two UserControls: the ToolBar and the class that wrapps my own QueryDesigner.
So what I want to do now, is to resize my Windows.Form which is encapsulated in the second UserControl whenever the size of the window, that contains these two UserControls, is modified.
I already tried to use the "Parent" property and the "FindForm()" method but both just return "null".
--> I do not unterstand how I can access these informations!
Please help me out!
View 1 Replies
ADVERTISEMENT
Jun 2, 2015
Recently we migrated our environment to 2012.
We are planning to implement Xevents in all the servers in place of Trace files and everything is working fine.
Is it possible to configure Extended event to trigger a mail whenever any event (example dead lock) occurs.
I have gone through so many websites but i never find.
View 13 Replies
View Related
Dec 14, 2006
Dear members,
In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication.
I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below :
protected System.Web.UI.WebControls.Label Label1;
private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser";
/*
comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate)
*/
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select suser_sname()";
conn.Open();
string userName = cmd.ExecuteScalar() as string;
conn.Close();
conn.Close();
Label1.Text = userName;
}
at web.config, I add :
<identity impersonate="false" userName="deltasqluser" password="" />
at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication",
at query analyzer, I login as "sa" and execute script below :
exec sp_grantdbaccess 'deltasqluser','northwind'
when I run the ASP.NET script, error at conn.Open(); with error message :
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ?
Regards,
Koronx
View 1 Replies
View Related
Oct 25, 2011
My SQL Server 2005 SP4 on Windows 2008 R2 is flooded with the below errors:-
Date  10/25/2011 10:55:46 AM
Log  SQL Server (Current - 10/25/2011 10:55:00 AM)
Source  spid
Message
Event Tracing for Windows failed to send an event. Send failures with the same error code may not be reported in the future. Error ID: 0, Event class ID: 54, Cause: (null).
Â
Is there a way I can trace it how it is coming? When I check input buffer for these ids, it looks like it is tracing everything. All the general application DMLs are coming in these spids.
View 2 Replies
View Related
Apr 8, 2008
I have been testing with the WMI Event Watcher Task, so that I can identify a change to a file.
The WQL is thus:
SELECT * FROM __InstanceModificationEvent within 30
WHERE targetinstance isa 'CIM_DataFile'
AND targetinstance.name = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\AdventureWorks.bak'
This polls every 30 secs and in the SSIS Event (ActionAtEvent in the WMI Task is set to fire the SSIS Event) I have a simple script task that runs a message box).
My understanding is that the event polls every 30 s and if there is a change on the AdventureWorks.bak file then the event is triggered and the script task will run producing the message.
However, when I run the package the message is occurring every 30s, meaning the event is continually firing even though there has been NO change to the AdventureWorks.bak file.
Am I correct in my understanding of how this should work and if so why is the event firing when it should not ?
View 2 Replies
View Related
May 31, 2007
Server 2003 SE SP1 5.2.3790 Sql Server 2000, SP 4, 8.00.2187 (latest hotfix rollup)
We fixed one issue, but it brought up another. the fix we applied stopped the ServicesActive access failure, but now we have a failure on MSSEARCH. The users this is affecting do NOT have admin rights on the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object AccessEvent ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domainuser
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:WINDOWSsystem32services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domainuser
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:WINDOWSsystem32services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: - Restricted Sid Count: 0 Access Mask: 0x2008D
View 4 Replies
View Related
Nov 2, 2007
Hi all,
Can we get the event properties by using a query?
Are there any extended stored procuder to get the above?
Scenario:
>Desktop>Right Click on My Computer
>Go to Manage and click
>Expand System Tools
>Expand Event Viewer
>Application
click on one event.We can get the log info which is the manual procudure.
But now i want to get the event properties through the Query analyzer...
Any help would be great?
Thanks,
View 4 Replies
View Related
Nov 24, 2000
I have a SQL 7.0 database Drill.mdf (19 MB) and Drill_log.ldf (594 MB).
After operation "shrink database" space allocated became as:
Data space Used Free Total
Drill 18,06MB 0,06MB 18,13MB
Transaction log space 20,79MB 545,70MB 566,49MB
Could I somehow decrease the size of Drill_log.ldf file?
View 3 Replies
View Related
Jul 17, 2007
I have a sql 2005 system and have a very large 25gb ldf file and a 200mb database.
Someone has set the initial size at 25gb so shrinking the file will not help.
I need to remove/add the file to gain space on the drive.
SQL 2000 you could just detach the DB and rename the ldf file and attach the db back and you are done. With 2005 you cannot do that.
View 1 Replies
View Related
Nov 16, 2005
Yes my DB file is 10MB but my LOG file (LDF) is 300MBis there a way to reduce or compres that one?thanx
View 2 Replies
View Related
Nov 3, 2007
Dear all,
How can I resize SQL -2005 log file ?
Please help me
Hasan
Hasan
View 3 Replies
View Related
Feb 12, 2008
Hi, I wish resize the allocated space of my DB.
It's 245GB, but the DB is 50GB.
I tryed this query:
use master
GO
ALTER DATABASE mydb
MODIFY FILE
(NAME = 'mydb_data',SIZE= 50000)
GO
but I receive an error:
Msg 5039, Level 16, State 1, Line 1
MODIFY FILE failed. Specified size is less than current size.
Can you help me?
Thanks
View 4 Replies
View Related
Apr 16, 2008
I have added a pie chart to my report but the legend is not wide enough. Is there a way of altering the width of the legend?
View 1 Replies
View Related
Jul 31, 2006
I am doing a report in SQL Server Reporting Services 2k5 , the report has a chart that displays data from a query. The question is:
Is possible to dynamically resize the area occupied by the chart depending on the amount of information (variations of a category) to be displayed on it ?
View 4 Replies
View Related
Jun 26, 2006
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
View 1 Replies
View Related
Apr 9, 2001
Stopping and starting the SQL should return tempdb to its initial size. It is not working for me.
Tempdb is up to 25 GB.
I tried deleting the mdf / ldf during stop, did not work.
View 2 Replies
View Related
Aug 24, 2007
Hi,
I have a very big report with 60 columns and some columns are invisible.
The problem is now if I have 30 columns that are invisible (hidden=TRUE), the report width still stays at 60 columns width, and the Horizontal scroll bar become very long and it just scroll to blanks.
I would like to know how to resize the report after it is generated?
Thanks.
Jon
View 5 Replies
View Related
Jun 12, 2007
I am trying to resize a COLUMN. Can I do this with the ALTER TABLE MODIFY command? I am getting the following error message when I try the "alter table [admin] modify [runFileTypes] NVARCHAR(250)" command.
" [ 1,21,modify ]"
command = ssceconn.CreateCommand()
command.CommandText = "alter table [admin] modify [runFileTypes] NVARCHAR(250)"
command.ExecuteNonQuery()
The only other option I can think of is to rename the old field, add a new field, copy the value of the old field to the new field, and delete the old field. I have some of the code below, but I am not sure how to copy the contents of the old field to the new field.
command = ssceconn.CreateCommand()
command.CommandText = "ALTER TABLE myTable RENAME COLUMN [oldField] TO [newField]"
command.ExecuteNonQuery()
command.CommandText = "ALTER TABLE myTable ADD COLUMN [oldField] varchar(500)"
command.ExecuteNonQuery()
command.CommandText = "ALTER TABLE myTable DROP [newField]"
command.ExecuteNonQuery()
View 3 Replies
View Related
Aug 17, 2006
Hi, I have a database with about 200Gigs allocated to filegroups and 200Megs data in it presently, and am trying to create a copy of the database on the same server - except I don't have enough diskspace free for another 200Gigs. Is there a way using copy database wizard, or restore that the filegroup allocations can be resized?
Thanks,
Chris
View 1 Replies
View Related
Apr 18, 2007
I have a report that has a certain number of columns that are hidden and when hidden they leave a lot of white space. Is there a way to detect when they are hidden and set the width property to 0 and then reverse the value when they are visible?
View 1 Replies
View Related
Jun 2, 2015
How can I resize a bitmap to fit the screen? I have inserted a bitmap using an external source.
View 4 Replies
View Related
Apr 8, 2008
I am linking to another SQL Server database to extract data into my own system. Following an increase in size on one of the columns in a table I am extracting, I am getting the following error:
'OLE DB provider 'SQLNCLI' for linked server 'gsc-rpt.svr.bankone.net' returned data that does not match expected data length for column '[gsc-rpt.svr.bankone.net].[Peregrine].[dbo].[scProblem].short_description'. The (maximum) expected data length is 100, while the returned data length is 148'
The column short_description has been increased from 100 to 1024. Writing a simple query, SELECT (max(len(short_description)) FROM dbo.Peregrine_Problem will generate the error, but if I embed the same SQL into an Excel VBA macro and connect to the server, it happily returns the result 1024. Our Access databases also link to the table on the remote server and handle the increased column size properly.
I have done everything I can think of, including deleting the linked server within SQL Server MS, and recreating it, but I can't override the setting of 100.
Any ideas?
View 3 Replies
View Related
Oct 22, 2007
We recently upgraded to SQL 2005 from SQL 2000. We have most of our issues ironed out however about every 1 minute there is a message in the Application Event log and the SQL log that states:
EVENT ID 18456 Login Failed for the users DOMAIN/ACCOUNT [CLIENT: <local machine>]
This is a state 16 message which I thought meant that the account does not have access to the default database. The account is actually the account that the SQL services run under.
Any ideas? We can't seem to figure this one out. We actually upgraded to 2005 from 2000 and had an error appear after every reboot that prevented the SQL Agent from running(This application has failed to start because GAPI32.dll was not found. Re-installing the application may fix this problem.) We did a full uninstall of SQL and reinstalled fresh and restored the databases from .bak files and that is when the EVENT ID 18546 started occuring every minute.
We don't have any SQL heavy hitters here so please be detailed with any possible solutions. That you very much for any help you can provide!
David
View 5 Replies
View Related
Oct 24, 2007
Hi,
We have a very severe issue in our production, and this is very very ugent to fix this issue, there was a job started on server on 10th October, 2007, for backup of database of 3.2 TB, which caused this issue on 18th October, 2007.
I cancelled that job and even restarted the server, but still there is same issue on the server.
I am using this command to expand the physical file,
ALTER DATABASE [ODS] MODIFY FILE ( NAME = N'ODSFG33File1', SIZE = 307200000KB )
Error:
MODIFY FILE encountered operating system error 1450(Insufficient system resources exist to complete the requested service.) while attempting to expand the physical file.
Server:
64bit Itanium Server with 4 Processors
4TB of SAN Storage
24GB of RAM
MS Windows 2003 Enterprise Edition with SP1
MS SQL Server 2005 (9.0.3152) Enterprise Edition with SP2
Database:
3.2 TB Size of Partitioned Database with 60 File Groups
Every File Group contains One month data in its only one physical File.
Physical Files are of different size between 10GB and 300GB.
Kind Regards,
Muhammad Imran.
View 8 Replies
View Related
Feb 3, 2014
I recently upgraded to on 2012 SP1 CU5 and have found the SSDT gui for SSIS to be almost unusable. I can't drag or resize items. Any time i try they either automagically shrink to the tiniest possible size, shoot off to some extreme or just shake uncontrollably I didn't have these problems on previous versions (dont remember what It was).
Is there a fix for this?
View 9 Replies
View Related
Sep 4, 2007
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
View 1 Replies
View Related
Apr 29, 2005
made my first web application using vb script. I am trying to use window authentication for my web page and try to give all permission based on window domain user account. Here is the connecting string I was using to connect to the sql server and it was working fine.
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"user id=ASP;" & _
"password=ASP;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
I made couple of changes so it run on based on window domain user.
1) my server is set on window and sql server
2) Web.config file – I set Authentication mode = “ Window�
3) I also added under set <authorization>
<deny users="?" />
</authorization>
4) change the connecting string to : ( Added "Integrated Security=True;" and removed line for user and password)
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"Integrated Security=True;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
5) run the application and now I am getting error said “Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.�
I was expecting window pop up log in to enter domain user and password and then verity the user and password against sql server and the take it from there. Where I made mistake. Need help.
View 1 Replies
View Related
Aug 24, 1999
How can I call the SQL Server environment from a MS DOS window ?
Is there a command to do that ?
I know i type SVRMGR23 using Oracle...
Thank you.
View 1 Replies
View Related
Dec 30, 2004
I need to make a homemade Search form for my users....one that they can press a button type in lastname or TM#, FirstName or SSN and BAM!!!!!! theres the results populated on the form. Anyone know of any good sites where I can obtain some info on how to create one of these or something??
View 9 Replies
View Related
Feb 16, 2007
Running sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it should be.
In this window I do not see System Administrator and System User column. I see a different window i.e. permission, Grantor, Grant, WithGrant, Deny columns.
Any thoughts please?
Thanks
View 3 Replies
View Related
Feb 27, 2007
hi frnds,
i want to view the runtime variable value in the watch window while the package is running,
how i will get that watch window. i searched all the menus but i didnt get it.
im using Microsoft Visual Studio 2005 for SSIS package.
View 1 Replies
View Related
May 14, 2008
Hello Guys,
One of the fields in my report is a web address (i.e. http://www.yahoo.com). Navigation property for this field is "Jump to URL". Users will access the report with a browser, using a "sharepoint-like" application. Default behavior of "Jump to URL" seems to be to open the link in the same window (or tab in IE7). Is there a way to force the link to be open in the new window?? Please let me know if you have any suggestions. Thanks!!
View 5 Replies
View Related
Mar 26, 2007
I honestly don't see where to view the watch window. Can someone please advise.
Thanks
View 5 Replies
View Related
