my COM+ app uses 2 sql server DBs on 2 different Servers to do its work. the first server contains all the data structures required for the com+ application to work. the second server is just a work server that process large batch jobs and posts the data back to server #1. We did this […]
2001-10-02
2 reads
Our SQL 2000 machine had SP1 installed recently and since then the SQL Agent stops with no warning and with no apparent pattern except mostly on the hour or half hour. e.g. 7:00 AM, 12:30 PM, 9:30 AM etc None of the tasks run by the agent have been executed at all the times that […]
2001-09-26
4 reads
Hello, Could some one please tell how to get the current Identity value from a table using Dynamic sql. My code is listed below. declare @qry nvarchar(500) declare @qry1 nvarchar(500) declare @tabName nvarchar(50) declare @x int set @tabName='tblCenters' set @qry = N'select @ident=ident_current('''+@tabName+''')' set @qry1 = N'@ident int' exec sp_executesql @qry, @qry1,@x print @x It […]
2001-08-28
27 reads
Well in an effort to catalog everything I've started the great scripting project! I already script backups, restores, adding/deleting users and general setup after initial install. What I'm looking for now is a way to add scheduled task via t-sql scripts instead of going to every box and using EM to add all the jobs […]
2001-08-27
2 reads
A developer told me he had installed a SQL 2000 Beta version of EM on his box. He now wants to install the real mccoy. I insert the SQL 2000 Standard CD. We get to the "Computer Name...Local Copy" screen. Pressing next gives the error message: A previous program installation created pending file operations on […]
2001-08-22
3 reads
I'm trying to use SQL-DMO to determine the size of the "northwind" database: Dim oSQLServer Dim oDatabase Set oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.Connect "tower2", "sa" Set oDatabase = oSQLServer.Databases("northwind") Msgbox oDatabase.Size but .Size always returns the results in MB (not fine enough for me). For example, on my computer it returns 5 (MB) while EM show […]
2001-08-20
3 reads
hello andy, what i mean by not displayed is that the value for that particular field is being shown as <"Long Text"> and nothing else will try convert ok will let u know if something clicks by using convert thanks keyur
2001-08-17
My datacenter has a 100 MBPS network. I sit outside the Data center in a 10 MBPS network. Here's the scenario: The 42 GB dump of a database is on Server X within the 100 MBPS network The restore has to happen on a server Y also within the same segment/network. My computer Z in […]
2001-07-08
2 reads
I am trying to change field type from 'char' to 'datetime', the enterprise manager gives error message stating "- Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been […]
2001-07-05
15 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers