RE: How many of you work with Oracle?
We have around 50+ SQL Servers and equal number of Oracle. Only two DBAs in our group knows both..I am still in the learning stage
2003-07-18
Excel
RE: Login and password in Excel file
Thanks Frank. You are the man. I modified your script according to my requirement. Can you please let me know how to add more columns in excel file. your script will add only one column. I think we need to modify the following line of code. SET @ObjProp='Application.ActiveWorkbook.Sheets(1).Cells(' + cast(@Counter as varchar(2)) + ', 1).value'
2003-07-15
1 reads
RE: Alternative for TOAD
I'll be honest, by clicking on a link here above i've found mssqlXpress, what is doing quite what i wanted. I wanted a tool so maintain on a visual clear way all my procedures, triggers stored in a database. The Edit Design in this app is quite the same as the one in EntrMgr but […]
2003-07-11
1 reads
RE: Primary Key constraint
The Transform Data Task Properties - Option tab allows you to specify "Max error count" which is supposed to allow the package to keep going until the maximum is reached. If you know about how many duplicates you have, you can experiment with this number. Given the unpredictability of data, I've not had good luck […]
2003-07-10
1 reads
RE: How many records can SQL Server handle?
I currently have one table that has 734,371,580 rows. I don't see any problems/slowness because of the size. -SQLBill
2003-07-08
RE: How to get all databases name from server
Why not use SQL-DMO? With this component you can create SQL Enterprise Manager like applications, with out going for the systemtables. Just add a reference to Microsoft SQLDMO Object Library. And this code will do the job: Dim oServer As New SQLDMO.SQLServer Dim oDatabases As SQLDMO.Databases Dim oDB As SQLDMO.Database oServer.Connect ServerName, UserName, Password Set […]
2003-07-08
RE: NULL values in source table don't add up
Thanks for your time and help, Michael, but, excuse me if i sound a bit dumb here, how do you add a catch-all level? Never heard of or about it before. Thanks, Ryan
2003-07-07
RE: Role script
quote: You may have to generate a script larger than intended and then extract the bit you want. In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab. Thank you. […]
2003-07-05
RE: Query scheduling!!!
You can do some cool things directly in tSQL using "WAITFOR" with "DELAY" or "TIME". Example below... use Northwind--for this example IF Object_ID('tempdb..##NewCategories') is not null drop table ##NewCategories Create Table ##NewCategories (CategoryID int, CreatedDate datetime)--This is the table being updated by the loop below go declare @iIDmin int, @iIDmax int--variable to hold max ID […]
2003-07-02
RE: Can't start server agent.
Determine what account the SQL Server agent is attempting to run under. Add that user account to the System Administrators role (sysadmin) on the SQL Server itself. In Enterprise Manager >> Security | Server Roles. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-30
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers