Hi Phill,Thanks for prompt reply... Actually Pls. find the the whole procedure... In which i am 1st import a text file. Then i have to Fetch the Table name from this file along with Column. And then insert into DB. Pls. find the whole procedure... for uor refrenceCreate PROC Sp_EnterTextFile @filename sysname as BEGIN SET […]
2005-02-03
I wish to discuss TSQL stored procedure logic setup with different user roles. I am a SQL server newbie getting to grips with user roles and writing TSQL for users and report tables. In MS access I have all users setup as ADMIN and use passwords and form protection techniques to protect the code. The ADMIN role allows […]
2005-02-02
Steve,Yes I choose append from the backup wizard, But I do not believe that I am appending to another backup file. This is how I go about running the manual backupRC on the DB and select Backup DB to invoke Backup wizard => select Transaction Log Backu => leave the Database/Name/Description names the way they […]
2005-02-02
2 subscriptions received 34 transactions versus the correct number of 169 that went to the other 3 subscriptions. Single distribution database on the publisher and indivual distribution agents for each subscription that are push. Does anyone know what may cause this? I don't even know where to begin to look.
2005-02-02
Hello,MSSQL 2000, SP3; Instance collation is Latin1_General_BIN.; Enterpris Manager DTS Import/Export Data toolI have a server that has 2 databases with 2 different collations:DB1 = SQL_Latin1_General_CPI_CI_ASDB2 = Latin1_General_BINI used DTS to import data from DB1 to DB2 using "Copy objects and data between SQL server databases" option. When I use sp_help 'tablename' against db2, the column […]
2005-02-02
47 reads
Actually, I found what I needed. Because DBCC INDEXDEFRAG is an online operation, I'm sure that it was is happening through the default maintenance plan. DBCC DBREINDEX is an off-line operation that rebuilds statistics as part of the process.I am assuming that the "check database integrity" option is performing DBCC CHECKDB.Ryan
2005-02-02
Morning AllWhen I run the following TSQLselect * from sysdatabasesit give me the location for my master Database asd:\mssql\MSSQL\data\master.mdfHowever, if I check the Db properties through Enterprise Manager, it reports it asd:\sql\MSSQL\data\master.mdfBoth files exist, have virtually the same timestamp, and are the same size. How do I establsh which is correct?ThanksGary
2005-01-31
I recently had to transfer about 25 DTS packages to a new server when I was setting up a development environment.Since the servers are identical I just installed SQL Server, checked to see that it was working, shut down the services and copied the data/log files to the new server. I restarted the services and […]
2005-01-27
1 reads
I have a table with the date and data elements in it.I need to produce a resultset in the following manner:On columns: Yesterday, WeekToDate, MonthToDate, Last Month, YearToDateOn rows: data element 1, data element 2, data element 3, ....What's the best way to query this table? It has to be fast for the front end.Thank […]
2005-01-25
I am currently experiencing some problems using the database role of dbo_ddladmin in SQL2K. I am adding an NT user group/ad group to the ddladmin role and the users are telling not only can they not add new objects they can't even do a simple select statement. I am not too familiar with SQL2K but […]
2005-01-21
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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