2004-03-19
bulk insert
RE: nt_username in sysprocesses table is blank in one server and not in the other.
Mike:I believe that you are on to something. However, I believe that it has to do with the Server and not with Client. You said “your tests involved changing the Client configuration only”. Was this on the Client or on the Server? The remote clients do not have the client Network Utility installed on their […]
2004-03-16
RE: SQL Server wont start after backup??
All, Thanks so much for your responses.Based on these two articles http://support.microsoft.com/default.aspx?scid=kb;en-us;814848 and http://support.microsoft.com/default.aspx?scid=kb;en-us;240240 this is our problem. To quickly rap them both up; files and folders have two names associated with them a long name a short name. Short name are applied as applications are installed. When a backups is preformed the short name […]
2004-03-12
RE: DTS Query
Here is the query...SELECT a.no as no, a.date as date, a.key as key, a.memo as memo, b.name as name FROM Cases_Table a INNER JOIN Dates_Table b on a.key = b.key WHERE b.Name LIKE '%TICKLER%' AND len(a.memo) > 0 ORDER BY name, date, no
2004-01-26
RE: Query Analyzer list of SQL Servers is wrong...
Okay, half of the problem is solved. Why isn't Instance B showing up in Query Analyzer?Because my crappy old firewall software decided today that it was evil and needs to be kept hidden. When I turn that off, it shows in the listHowever, the other question remains. Why does it show these other two instances […]
2004-01-23
1 reads
changing columns in transactional replication???
I'm new to replication. It appears that when I create a publication and subscriber this works fine, but it will not allow me to change a published article, i.e. change a column name or length, etc. I see you can add or delete a column from a published article under the publication properties, but how […]
2004-01-23
RE: find who accessed
sorry Brian it's sql server login. anyway i changed our server audit level to success.seems like i need 2 restart our server.i'll restart our server when there r no logged in users. thanks for ur time. cheers
2003-12-30
RE: Import and export data
Can i do some thing like this?. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE EXPORT_IMPORT_DATA(@direction CHAR(20)) AS DECLARE @Table_Name CHAR(100) DECLARE @sql CHAR(200) DECLARE tablename_cursor CURSOR FOR SELECT name FROM sysobjects WHERE xtype = 'U' OPEN tablename_cursor FETCH FROM tablename_cursor INTO @Table_Name WHILE @@fetch_status = 0 BEGIN BEGIN TRANSACTION IF @direction = […]
2003-11-21
1 reads
RE: DataBase Owner
quote: How can I change the owner of a Database for all users can access ??? Now, my database has an owner but only this user can access to the tables of the DB. Thanks.
2003-11-19
1 reads
RE: DTS Connection - ANSI_NULLS setting
quote: I have had this problem before and the solution was to create the procedure from QA not EM. Do you have to create the proc from DTS? Could you not call the procedure from DTS? The point is to create the view dynamically and this is only one step in a very complex DTS […]
2003-11-19
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